topic Piechart Help in presentation in QlikView

Piechart Help in presentation

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

Hello Team,

Need help in representation of piechart. Please find attached file, where i dont want to show the 0% in the piechart. I have tried supress 0 value option but it havent worked as values are not exact 0 that are like 0.000056 or 0.0045 etc.

I dont want to show it.

Regards,

Suryakant

Re: Piechart Help in presentation

ahaahaaha — Mon, 27 Mar 2017 08:27:51 GMT

Hi Suryakant,

Can this chart setting help?

Regards,

Andrey

Re: Piechart Help in presentation

suryakant241187 — Mon, 27 Mar 2017 09:13:01 GMT

I dont have used dimension.. i have written expression for the values. is there any other way..?

Regards,

Suryakant

Re: Piechart Help in presentation

awhitfield — Mon, 27 Mar 2017 09:17:14 GMT

Ok, so can you supply sample data, the expression, or better still an example QVW?

Andy

Re: Piechart Help in presentation

suryakant241187 — Mon, 27 Mar 2017 09:24:30 GMT

I have used 4 expressions:

e.g

Billable Hours:

=dual(sum(Fin_BillableHours) & chr(10) &

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

, sum(Fin_BillableHours))

Vacation:

=dual(sum(Vacation) & chr(10) &

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

, sum(Vacation))

Idle:

=dual((Fin_Idle) & chr(10) &

num( (Fin_Idle)/Total_Fin, '0%')

, (Fin_Idle))

and 2 mores.. from some of these expression i m getting value like 0.0000456 or 0.0056 etc. and i dont want to show it.

Regards,

Suryakant