Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight Table Issue

I have a straight table and I am suppressing the 0 values, but still I am still showing  for LOB called "PRF" 0 values, for 2014, but for 2015  I dont see PRF . 

I dont expect to see PRF for either year cuz its 0 for both 2014 and 2015.

Any idea whats going on here

1 Solution

Accepted Solutions
sunny_talwar

Is there a possibility that they might have values in decimals? like 0.001 rounded to 0?

View solution in original post

3 Replies
sunny_talwar

Is there a possibility that they might have values in decimals? like 0.001 rounded to 0?

Not applicable
Author

Yes you are right .  Please see  the attached.  How can I solve it

sunny_talwar

I guess try using Round() function around your expression -> Round(Expression) or Ceil(Expression) or Floor(Expression)