Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show values with condition

I want to show only rows 'NameProduct' (column 1)  with condition negative difference between columns 2 and 3 :

Column 1 = Dimension = NameProduct

Column 2 = Expression = Sum(QuantityProductInventory)

Column 3 = Expression = Min(SafetyStockLevel)

Column 4 = Expression = Sum(QuantityProductInventory) - Min(SafetyStockLevel)

1 Solution

Accepted Solutions
maxgro
MVP
MVP

you can try with a calculated dimension

if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel),   NameProduct)<0, NameProduct)

and check the "Suppress When Value is Null" flag in Dimension tab

View solution in original post

2 Replies
maxgro
MVP
MVP

you can try with a calculated dimension

if(aggr(Sum(QuantityProductInventory) - Min(SafetyStockLevel),   NameProduct)<0, NameProduct)

and check the "Suppress When Value is Null" flag in Dimension tab

Not applicable
Author

Perfect !!! Thx a lot...

Stanley