Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Eliminate negative zero


When a value is rounded off to two decimals, -0.0001 is rounding of to -0.00 it should be 0.00.

When we round in excel, -0.0001 is rounded to 0.00 or 0. I need same result in qlik also.

1 Reply

Use the round function: round(sum(b),0.01)

And if you want to display zero values then disable the Suppress Zero-Values option on the Presentation tab.

talk is cheap, supply exceeds demand