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 QlikView Pie Chart demo, we are going to use the data present in the following Excel table.

Pie Chart in QlikView 1

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

Pie Chart in QlikView 2

Create a Pie Chart in QlikView

In this QlikView 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 QlikView 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.

Pie Chart in QlikView 3

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

Pie Chart in QlikView 4

Either way, it opens a new window to create a Pie Chart. Here, we assigned a new name to our chart, and then selected the Pie Chart as the chart 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.

Pie Chart in QlikView 6

Clicking the Next button at 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 of a Pie chart. Here, we can select the 3D Pie chart or 2D Pie chart.

Pie Chart in QlikView 10

Presentation page is to alter the QlikView Pie chart settings:

  • Pop-up Labels: Hovering 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 mouse on the pie chart slice push a bit forward (we can say it 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 to change the QlikView Pie Chart Color pattern. Here, we are leaving it default settings.

Pie Chart in QlikView 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.

Pie Chart in QlikView 13

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

Pie Chart in QlikView 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