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

Eliminate negative zero

Hi,

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
Gysbert_Wassenaar

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