Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How exclude line from table?

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?

0 Replies