Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

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
Contributor

Re: Expression - surpressing nulls

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

Community Browser