Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Breezy
Creator II
Creator II

Bar chart rounding numbers on y-axis?

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%

rounding.JPG

Labels (1)
  • Chart

4 Replies
edwin
Master II
Master II

have you tried using num(your aggregation, '##%')  assuming you are getting a percentage

Breezy
Creator II
Creator II
Author

I'm not sure what you mean. My formula is:

 

(Count( distinct [reptile )/Count([bugs))*100

saranyadurai
Contributor III
Contributor III

Hi @Breezy ,

May be try to change the number format, 

saranyadurai_0-1653311346238.png

or 

Num(((Count( distinct [reptile )/Count([bugs))*100),'#,##0%')

Hope, this will help you.

 

Thanks

 

 

 

Angela_Zhou
Contributor III
Contributor III

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 

 

Angela Z.