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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)