topic Re: Expression - surpressing nulls in QlikView https://community.qlik.com/t5/QlikView/Expression-surpressing-nulls/m-p/469302#M560771 <HTML><HEAD></HEAD><BODY><P>sorry - i realized I can't use "above" in this case. It wouldn't make sense.</P></BODY></HTML> Thu, 18 Apr 2013 19:40:49 GMT zagzebski 2013-04-18T19:40:49Z Expression - surpressing nulls https://community.qlik.com/t5/QlikView/Expression-surpressing-nulls/m-p/469301#M560770 <HTML><HEAD></HEAD><BODY><P>I have a pretty simply straight table with 3 dimensions and the following expression;</P><P></P><P>=if(right([Incurred Year Month],2)=[Renewal Month]</P><P>&nbsp; ,if(above([Group ID])=[Group ID]</P><P>&nbsp;&nbsp; ,2,''),'')</P><P></P><P>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.</P></BODY></HTML> Thu, 18 Apr 2013 19:38:58 GMT https://community.qlik.com/t5/QlikView/Expression-surpressing-nulls/m-p/469301#M560770 zagzebski 2013-04-18T19:38:58Z Re: Expression - surpressing nulls https://community.qlik.com/t5/QlikView/Expression-surpressing-nulls/m-p/469302#M560771 <HTML><HEAD></HEAD><BODY><P>sorry - i realized I can't use "above" in this case. It wouldn't make sense.</P></BODY></HTML> Thu, 18 Apr 2013 19:40:49 GMT https://community.qlik.com/t5/QlikView/Expression-surpressing-nulls/m-p/469302#M560771 zagzebski 2013-04-18T19:40:49Z