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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.