How to suppress zero or Null

[dseelam]

Hello Qlik folks,

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

[neelamsaroha157]

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.

[PabloTrevisan]

Hi Dinesh, You could try check this option on 'Hand' field... Note that in my example the field name is Sales.

SUPRESS WHEN VALUE IS NULL

I hope it help's

[vishsaggi · Accepted solution]

You need to create a calculated dimension like

= Aggr(If(Sum(Onhand)>0, ItemNumber), Itemnumber)

Then use supress 0 values and supress when value is null

[dseelam]

Thanks Vishwa