Qlik Sense Pie Chart Show Percentage And Value
Qlik Sense is a powerful data visualization tool that helps businesses make informed decisions. One of the most commonly used types of visualizations is the pie chart. With Qlik Sense, you can easily create pie charts that show both the percentage and value of each slice. Here's how.
Creating a Pie Chart in Qlik Sense
The first step in creating a pie chart in Qlik Sense is to add the chart object to your sheet. To do this, click on the "Add object" button in the toolbar and select "Chart."
Next, select "Pie chart" as the chart type and drag and drop the relevant data fields onto the chart. You can customize the appearance of the chart by changing the colors and fonts, adding labels, and adjusting the size and position.
Show Percentage and Value in a Pie Chart
To show both the percentage and value of each slice in your pie chart, you can add a custom expression. Click on the "Data" tab in the properties panel and select "Add new expression."
In the expression editor, enter the following formula:
=Num(Sum(Sales)/Sum(Total Sales),'#%')&'('&Sum(Sales)&')In this example, we are using the "Sales" field to calculate the percentage and value of each slice. You can replace this with any relevant data field in your own chart.
Customizing the Display
Once you have added the custom expression, you can customize the display of the percentage and value labels. Click on the "Presentation" tab in the properties panel and select "Data labels."
Here, you can choose to display the percentage, value, or both, as well as adjust the position, font, and color of the labels.
Conclusion
By following these simple steps, you can create a pie chart in Qlik Sense that shows both the percentage and value of each slice. This can help you gain a better understanding of your data and make more informed decisions for your business.
