Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using Qlik Sense. I just made a bar chart and this is my Y-axis. How do I get rid of the decimal point? I want it to say 80 instead of 80.0. Also, is there a way to change it from 80.0 to 80%
have you tried using num(your aggregation, '##%') assuming you are getting a percentage
I'm not sure what you mean. My formula is:
(Count( distinct [reptile )/Count([bugs))*100
Hi @Breezy ,
May be try to change the number format,
or
Num(((Count( distinct [reptile )/Count([bugs))*100),'#,##0%')
Hope, this will help you.
Thanks
Try remove * 100 out of your formula, just as
Count( distinct [reptile )/Count([bugs)
Then, change this number format of this formula measure as 12% as the screenshot of @saranyadurai