Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
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.