How exclude line from table?

Wed, 21 May 2014 06:10:30 GMT

I have table with this colums:

ItemId - invent item Id (dimension)

SalesQty - sales qty (expression)

InventQty - qty on location (expression)

LastPricePurch - last purch price (expression)

LastPriceSales - last sales price (expression)

I want see in table only line with ItemId have not null value SalesQty or InventQty, but may be this ItemId have LastPricePurch and LastPriceSales and option on Dimension "Supress when value is null" - not working.

Now I write expression in Dimension: =aggr(If(Alt($(SalesQty),0)<>0 OR Alt($(InventQty),0)<> 0,ItemId ),ItemId )

It's work, but slowly - how I can optimaze this situation?

topic How exclude line from table? in QlikView

How exclude line from table?