Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Pie chart show incorrect item are majority of slice

HI All,

In pie chart when using measure expression as number formatting, pie chart is showing incorrect pie slice share
below is the expression used 

=pick(match(-1,SUM(Sales)>=1000000000,SUM(Sales)>=1000000,SUM(Sales)>=1000),
num(SUM(Sales)/1000000000 ,'#,##0.0 B'),
num(SUM(Sales)/1000000 ,'#,##0.0 M'),
num(SUM(Sales)/1000,'#,##0.0 K'))

Qlik1_User1_0-1656311842721.png

 

 

Qlik1_User1_1-1656312312298.png

As here we can see dimension with 400.5k have more slice area while dimension with value 58.4M has less slice area.
Please help here.

Labels (5)
1 Solution

Accepted Solutions
Qlik1_User1
Specialist
Specialist
Author

with Dual expression is working
=DUAL(pick(match(-1,
SUM(Sales)>=1000000000,SUM(Sales)>=1000000,SUM(Sales)>=1000),
num(SUM(Sales)/1000000000 ,'#,##0.0 B'),
num(SUM(Sales)/1000000 ,'#,##0.0 M'),
num(SUM(Sales)/1000,'#,##0.0 K')),UM(Sales))

View solution in original post

2 Replies
Kimberly748
Contributor
Contributor

Comparing pie charts of different sizes could be misleading as people cannot accurately read the comparative area of circles. The usage of thin slices, which are hard to discern, may be difficult to interpret. The usage of percentages as labels on a pie chart can be misleading when the sample size is small. Emory Healthcare Patient Portal

Qlik1_User1
Specialist
Specialist
Author

with Dual expression is working
=DUAL(pick(match(-1,
SUM(Sales)>=1000000000,SUM(Sales)>=1000000,SUM(Sales)>=1000),
num(SUM(Sales)/1000000000 ,'#,##0.0 B'),
num(SUM(Sales)/1000000 ,'#,##0.0 M'),
num(SUM(Sales)/1000,'#,##0.0 K')),UM(Sales))