Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.

1 Reply
zagzebski
Creator
Creator
Author

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