Discussion board where members can get started with QlikView.
I use the below expression to show number and percentage.
But, the total of % of the pie chart is not equal to 100%.
dual(NUM(SUM(Job)/SUM(Total Job), '#,##0%') & ' / ' & Num(SUM(Job), '#,##0'), Num(SUM(Job), '#,##0'))
I know it won't help here but this is may endless mission on fighting with pie charts
Is it far off 100%? If not, it might just be down to rounding.
Do you have any NULL values in the dimension may be? Check if you are supressing NULL values for your Dimension?