topic Re: How to suppress zero or Null in QlikView https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91073#M603339 <HTML><HEAD></HEAD><BODY><P>Hi Dinesh, You could try check this option on 'Hand' field... Note that in my example the field name is Sales.</P><P></P><P><STRONG>SUPRESS WHEN VALUE IS NULL</STRONG></P><P><IMG __jive_id="209455" alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209455_Screenshot_1.jpg" style="height: auto;" /></P><P></P><P>I hope it help's</P></BODY></HTML> Tue, 31 Jul 2018 19:02:57 GMT PabloTrevisan 2018-07-31T19:02:57Z How to suppress zero or Null https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91071#M603337 <HTML><HEAD></HEAD><BODY><P>Hello Qlik folks, </P><P></P><P>How to suppress below first record where On hand = 0, expression = sum(OnHand) this is a stright table, cant remove cost and say where item = null</P><P></P><P><IMG alt="Remote Desktop Connection.png" class="jive-image image-1" src="/legacyfs/online/209463_Remote Desktop Connection.png" style="height: 48px; width: 620px;" /></P></BODY></HTML> Tue, 31 Jul 2018 18:46:03 GMT https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91071#M603337 dseelam 2018-07-31T18:46:03Z Re: How to suppress zero or Null https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91072#M603338 <HTML><HEAD></HEAD><BODY><P>If 'suppress null' is not working then may be you can include this condition in your expressions. Share a sample to look into more details.</P></BODY></HTML> Tue, 31 Jul 2018 18:54:42 GMT https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91072#M603338 neelamsaroha157 2018-07-31T18:54:42Z Re: How to suppress zero or Null https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91073#M603339 <HTML><HEAD></HEAD><BODY><P>Hi Dinesh, You could try check this option on 'Hand' field... Note that in my example the field name is Sales.</P><P></P><P><STRONG>SUPRESS WHEN VALUE IS NULL</STRONG></P><P><IMG __jive_id="209455" alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/209455_Screenshot_1.jpg" style="height: auto;" /></P><P></P><P>I hope it help's</P></BODY></HTML> Tue, 31 Jul 2018 19:02:57 GMT https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91073#M603339 PabloTrevisan 2018-07-31T19:02:57Z Re: How to suppress zero or Null https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91074#M603340 <HTML><HEAD></HEAD><BODY><P>You need to create a calculated dimension like </P><P></P><P>= Aggr(If(Sum(Onhand)&gt;0, ItemNumber), Itemnumber) </P><P></P><P>Then use supress 0 values and supress when value is null</P></BODY></HTML> Tue, 31 Jul 2018 19:07:45 GMT https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91074#M603340 vishsaggi 2018-07-31T19:07:45Z Re: How to suppress zero or Null https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91075#M603341 <HTML><HEAD></HEAD><BODY><P>Thanks Vishwa</P></BODY></HTML> Tue, 31 Jul 2018 19:53:42 GMT https://community.qlik.com/t5/QlikView/How-to-suppress-zero-or-Null/m-p/91075#M603341 dseelam 2018-07-31T19:53:42Z