Tutorial Gateway

  • C Language
  • Java
  • R
  • SQL
  • MySQL
  • Python
  • BI Tools
    • Informatica
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • QlikView
  • Js

Pie Chart in QlikView

by suresh

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.

Pie Chart in QlikView 1

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.

Pie Chart in QlikView 2

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.

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 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

Pie Chart in QlikView 5

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.

Pie Chart in QlikView 6

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

Pie Chart in QlikView 7

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

Pie Chart in QlikView 8

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.

Pie Chart in QlikView 9

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.

Pie Chart in QlikView 10

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.

Pie Chart in QlikView 11

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.

Pie Chart in QlikView 12

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.

Pie Chart in QlikView 13

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

Pie Chart in QlikView 14

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

Pie Chart in QlikView 15

Now you can see our newly created Pie Chart in QlikView.

Pie Chart in QlikView 16

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.

Pie Chart in QlikView 17

Thank You for Visiting Our Blog

Placed Under: QlikView

Trending Posts

SSRS Matrix Report

Create SQL Server Roles

Power BI Stacked Bar Chart

Introduction to Stored Procedures in SQL Server

SQL TRANSLATE Function

Tableau Text Label

Python LOG2

Change Data Types of a Column in Power BI

JavaScript COS

Python Program to Print Reverse Mirrored Right Triangle Star Pattern

  • C Programs
  • Java Programs
  • SQL FAQ’s
  • Python Programs
  • SSIS
  • Tableau
  • JavaScript

Copyright © 2019 | Tutorial Gateway· All Rights Reserved by Suresh

Home | About Us | Contact Us | Privacy Policy