topic Help in Piechart Qlikview in QlikView

Help in Piechart Qlikview

suryakant241187 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Help in Piechart Qlikview

techvarun — Thu, 05 Oct 2017 07:30:00 GMT

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

Re: Help in Piechart Qlikview

prat1507 — Thu, 05 Oct 2017 07:32:39 GMT

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

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

Regards
Pratyush

Re: Help in Piechart Qlikview

suryakant241187 — Thu, 05 Oct 2017 09:15:54 GMT

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

Re: Help in Piechart Qlikview

techvarun — Thu, 05 Oct 2017 09:23:22 GMT

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.

Re: Help in Piechart Qlikview

suryakant241187 — Thu, 05 Oct 2017 11:29:50 GMT

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.

Re: Help in Piechart Qlikview

suryakant241187 — Thu, 05 Oct 2017 11:43:27 GMT

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

Re: Help in Piechart Qlikview

techvarun — Mon, 09 Oct 2017 02:53:52 GMT

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

Re: Help in Piechart Qlikview

suryakant241187 — Mon, 09 Oct 2017 09:25:00 GMT

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

Re: Help in Piechart Qlikview

techvarun — Mon, 09 Oct 2017 10:00:23 GMT

Check the attached.

Re: Help in Piechart Qlikview

suryakant241187 — Mon, 09 Oct 2017 12:01:48 GMT

Hi.

Thanks for solution. Can we fix the size of piechart? and we only want to show the percentage on piechart.

Regards,

Suryakant

Re: Help in Piechart Qlikview

techvarun — Tue, 10 Oct 2017 03:58:45 GMT

Its showing both the number and percentage since you are using the Dual function.

I adjusted the expression a bit and check the solution feasibility.

Fixing the size of a pie chart isn't possible since the re-size happens depends on the label and legends.

Pie Chart 'Size With Data' | Qlik Community‌

How To Prevent Pie Chart From Resizing? | Qlik Community