Help in Piechart Qlikview

[suryakant241187]

Hi,

I have created 2 piechart which is showing the percentage and the number of values, but i need to exclude the records whoes value is 0. i have checked unchecked supress Zero values option but not working.

Help please.

[techvarun]

Share a sample app with expected result.

Suppress zero will exclude the expression results which is zero and not at the application level.

you may need to remove the zero values @ DataModel level itself

[prat1507]

Hi

Go into expressions and add if(YourExpression<>0,YourExpression).

Here YourExpression is the expression you're using in pie.

Regards
Pratyush

[suryakant241187]

Hi,Please find attached sample example.. where 0 values components i don not want in the chart. I have attached expression as well.

[techvarun]

I think the zeros which are showing in the Pie chart is not actually zeroes.

(0.0000006 is not zero) that's the reason it is not getting suppressed.

Use Floor() function to round down to zero.

[suryakant241187]

Hello,

Its not working properly i am using the below expression:

=if(dual(sum(Management_Internal_meetings) & chr(10) &

num( sum(Management_Internal_meetings)/Total_Fin, '0%')

, sum(Management_Internal_meetings))<>0, sum(Management_Internal_meetings) & chr(10) &

num( sum(Management_Internal_meetings)/Total_Fin, '0%')

, sum(Management_Internal_meetings))

which is hiding non zero values as well.

[suryakant241187]

I tried floor function. it not worked for me:( because some of has exact 0 value.

[techvarun]

Would you mind sharing a sample app with Dummy data to understand better

[suryakant241187]

Hi Varun and all,

Please find aatched example where i dont want to show the idle,sickness,Training, missing etc data as it is 0.

Help please.

Regards,

Suryakant

[techvarun]

Check the attached.