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.
From the screenshot below, see that we are loading the above specified excel sheet into the QlikView. Refer Import data from Excel to QlikView article to understand importing the excel tables.
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.
Second approach: Please navigate to Layout Menu, select the New Sheet Object, and then select the Charts.. option
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
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.
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
Click the OK button to close the edit expression window, and then click the Next button.
Here, specify the sorting order for the dimensions. In this example, we sort the country Names in Ascending order.
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.
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.
The Colors page is very useful to change the QlikView Pie Chart Color pattern. Here, we are leaving it default settings.
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.
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
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.
Now, see our newly created Pie Chart in QlikView.
Let us hover over the mouse in the Australia region. From the screenshot below, see it is slicing up with the Data label.