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: 
Anonymous
Not applicable

How to round up percentage results?

Hi,

I have a chart that is displaying values as 44.19%, 28.97%, etc. I need to not display the decimals but that the values are rounded up.

Is this possible?

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be all you need to do is to go on the numbers tab and select integer with Percentage checked off

View solution in original post

6 Replies
sunny_talwar

May be like this:

Round(Expression, 0.01)

sunny_talwar

or

Ceil(Expression, 0.01)

sacosta5
Contributor III
Contributor III

Hi...

Try  =>  Floor(Your Formula).

Rounding Errors

Anonymous
Not applicable
Author

My expression is Count ({$}  AutoID)

I have added Round and ceil but nothing happened.  .

Ceil(Count ({$}  AutoID),0.01)

Round(Count ({$}  AutoID),0.01)

sunny_talwar

May be all you need to do is to go on the numbers tab and select integer with Percentage checked off

Anonymous
Not applicable
Author

This is what I need