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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Felipe02
Contributor III
Contributor III

Format Numbers

Guys, how do I make qlik only round when the value is above 0.60, for example 89.60 = 90% and 89.50 = 89%?

2 Replies
LRuCelver
Partner - Creator III
Partner - Creator III

Dual(If(Number - Floor(Number) > 0.6, Ceil(Number), Floor(Number)), Number)

You might have to play around with factors of 10 a bit to get to the number of decimal places you want.

Felipe02
Contributor III
Contributor III
Author

If it has decimal places 0.60, will it round up?