Pie Chart in QlikView

Pie Chart in QlikView is very useful to display the Country wise, Region Wise Sales, etc. Let us see how to Create Pie Chart in QlikView with an example. For this Pie Chart demo, we are going to use the data present in the following Excel table.

Excel File 1

From the screenshot below, see that we are loading the above specified excel sheet into the QlikView.

Load Excel File 2

Create a Pie Chart in QlikView

In this Pie Chart example, we find out which country had the maximum share (big slice) of the sales. For this, we are going to use the Country Column as the dimension data, and the Sales Amount expression as the slice size.

We can create a pie chart in multiple ways: Right-click on the Report area opens the Context menu. Please select the New Sheet Object, and then select the Charts.. option.

Choose New Sheet Object and then Charts from Context menu 3

Second approach: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option

Go to Layout Menu and choose new sheet object 4

Either way, it opens a new window to create a Pie Chart. Here, we assigned a new name, and then selected the Pie Chart as the type

Pie Chart in QlikView 5

Please select the Dimension column to use in the QlikView Pie chart. For this example, we are adding the Country dimension to the used dimension section. Refer Import data from Excel to QlikView article in QlikView to understand importing the excel tables.

Add columns to user dimensions 6

Clicking the Next button at the Dimension page opens the Expression page. On top of that, a pop-up window called Edit Expression opened. Use this window to write the custom expression for the QlikView Pie Chart data, or select the Columns.

Here, we are selecting the Filed as Sales Amount, and Aggregation as Sum. Note, if you know how to write an expression, then write it on the empty space under the Expression OK section.

Pie Chart in QlikView 7

Click the OK button to close the edit expression window, and then click the Next button.

Pie Chart in QlikView 8

Here, specify the sorting order for the dimensions. In this example, we sort the country Names in Ascending order.

Pie Chart in QlikView 9

The next page is to change the look and style. Here, we can select the 3D or 2D Pie chart.

Pie Chart in QlikView 10

Presentation page is to alter the QlikView Pie chart settings:

  • Pop-up Labels: Hovering the mouse on the pie chart displays the corresponding Expression Value and the Dimension name. In this example, it displays the Country Name and Sales Amount
  • Suppress Zero-Values: Ignore the zeros
  • Suppress Missing: Ignore the Nulls
  • Highlight: Hovering the mouse on the pie chart slice pushes a bit forward (we can say it is highlighted).
  • Show Legend: Do you want to show the legend or not? If so, checkmark this option; otherwise, uncheck it.
Pie Chart in QlikView 11

The Colors page is very useful for changing the QlikView Pie Chart Color pattern. Here, we are leaving it default settings.

Change Colors 12

Next, we are formatting the Expression value. It only reflects when we display the data labels or data points. As we all know, the Sum of Sales Amount is money, so we are selecting the money.

Format Numbers to Money 13

Please change the Font family, style, and font size as per requirements. Here, we change the Font to Calibri and the font size to 12

Format the Font Style, Family, and Size 14

The Caption page stylized the QlikView Pie Chart Caption. It means color, background, position, etc. Once completed, click the Finish button. Here, we changed the Font color.

Pie Chart in QlikView 15

Now, see our newly created Pie Chart in QlikView.

Pie Chart in QlikView 16

Let us hover over the mouse in the Australia region. From the screenshot below, see it is slicing up with the Data label.

Pie Chart in QlikView 17