Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohit1947
Contributor II
Contributor II

Suppress missing or zero values is not working

Hi All,

I have YOY % calculation where I using below farmula.

if( fabs($(PY)) > 1 ,(( $(YTD) - $(PY) )/ $(PY)),null())

But it's still showing that null value in Table.

If you look at the value of %YOY column there is null value is coming for new. If i disable YOY column it is suppressing the value the row for new.

One more thing i noticed it's suppressing the value of book 5 under new but not new(as total).

It's a straight table i m using over here.

Can some body help me in this?        

sample.png

Thanks

10 Replies
sunny_talwar

Would sharing a sample a possibility?