Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
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
Thanks Vishwa