Pie Chart in QlikView is very useful to display the Country wise, Region Wise Sales etc. In this article we will show you, How to Create Pie Chart in QlikView with example. For this we are going to use the data present in the following Excel table.
From the below screenshot you can see that, we are loading the above specified excel sheet into the QlikView. I suggest you to refer Import data from Excel to QlikView article to understand the steps involved in importing the excel tables.
Create a Pie Chart in QlikView
In this example we will 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 will open the Context menu. From 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 ways, it will open a new window to create a Pie Chart. As you can see from the below screenshot, we assigned a new name to our chart, and then selected the Pie Chart as the chart type
Please select the Dimension column that you want to use in your Pie chart. For this example, we are adding the Country dimension to the used dimension section.
Once you click the Next button at Dimension page, it will open the Expression page and on top of that, a pop up window called Edit Expression will be opened. You can use this window to write the custom expression for the Pie Chart data, or you can select the Columns.
As you can see from the below screenshot, we are selecting the Filed as Sales Amount, and Aggregation as Sum. Note, if you know how to write an expression then you can simply write it on the empty space under the Expression OK section
Click OK button to close the edit expression window, and then click Next button.
Here you can specify the sorting order for the dimensions. In this example, you can sort the countries by Name in Ascending, or Descending order.
Next page is used to change the look, and style of a Pie chart. Here you can select the 3D Pie chart, or 2D Pie chart.
Presentation page is used to alter the Pie chart settings:
- Pop-up Labels: When you hover your mouse on pie chart, It will display the corresponding Expression Value, and the Dimension name. In this example, it will display the Country Name, and Sales Amount
- Suppress Zero-Values: It will ignore the zeros
- Suppress Missing: It will ignore the Nulls
- Highlight: When you hover your mouse on pie chart, the slice will push a bit forward (we can say highlighted)
- Show Legend: Do you want to show the legend or not?. If so, check mark this option otherwise, uncheck it.
Colors page is very useful to change the Color pattern of the Pie chart. From the below screenshot you can see that, we are leaving it default settings.
Next, we are formatting the Expression value. This will be reflected only when you 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 your requirements. From the below screenshot you can see that, we changes the Font to Calibri, and font size to 12
Caption page is used to stylized the QlikView Pie Chart Caption. It means, color, background, position etc. Once you done, click the Finish button. As you can see we changed the Font color
Now you can see our newly created Pie Chart in QlikView.
Let me hover over my mouse on Australia region. As you can see from the below screenshot, it is slicing up with the Data label.
Thank You for Visiting Our Blog
Leave a Reply