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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Expression - surpressing nulls

I have a pretty simply straight table with 3 dimensions and the following expression;

=if(right([Incurred Year Month],2)=[Renewal Month]

  ,if(above([Group ID])=[Group ID]

   ,2,''),'')

The epxression works but I am trying to get figure out a way to surpress the line of data if there is no value. It keeps showing every line even if there is no value in it and I have checked the "Supress When value is null" checkbox for each dimension.

Labels (1)
1 Reply
zagzebski
Creator
Creator
Author

sorry - i realized I can't use "above" in this case. It wouldn't make sense.