Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
suryakant241187
Partner - Contributor III
Partner - Contributor III

Piechart Help in presentation

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

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi Suryakant,

Can this chart setting help?

1.jpg

Regards,

Andrey

suryakant241187
Partner - Contributor III
Partner - Contributor III
Author

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

Regards,

Suryakant

awhitfield
Partner - Champion
Partner - Champion

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

Andy

suryakant241187
Partner - Contributor III
Partner - Contributor III
Author

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