Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

devourThePie3.gif?format=750w

Highlighted
Creator III
Creator III

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

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