Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wendytham
Contributor II
Contributor II

Pie chart with number and percentage

Hi,

I use the below expression to show number and percentage.

But, the total of % of the pie chart is not equal to 100%.

Please assist.

Thank you.

dual(NUM(SUM(Job)/SUM(Total Job), '#,##0%') & ' / ' & Num(SUM(Job), '#,##0'), Num(SUM(Job), '#,##0'))

Untitled.png

3 Replies
tomasz_tru
Specialist
Specialist

I know it won't help here but this is may endless mission on fighting with pie charts

devourThePie3.gif?format=750w

jensmunnichs
Creator III
Creator III

Is it far off 100%? If not, it might just be down to rounding.

rajivmeher
Creator
Creator

Hi Wendy

Do you have any NULL values in the dimension may be? Check if you are supressing NULL values for your Dimension?

Regards

Rajiv.