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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Truncate numeric expression

I have a chart that has an expression. Currently the number format is set to Fixed to 2 Decimals. This rounding to 2 decimals is causing some problems when looking at the data. Something that evaluates to 0.9995 is being displayed as 1.0. What I would like to do is leave it displayed in the chart as 0.99. I looked for some kind of truncate function but am unable to find anything. Is there a way to truncate this expression in the chart to 2 decimal places?

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

Floor will truncate decimals as you like

View solution in original post

2 Replies
Not applicable
Author

Floor will truncate decimals as you like

Not applicable
Author

Thanks. I knew there had to be a way to do this.