I have the following tables:
Backlog (can have multiple records for the same customer and product)
| Customer | Product | Backlog |
|---|
| A | X | 40 |
| A | X | 50 |
| A | Y | 100 |
Inventory (single record for each product)
WIP (multiple records for the same product)
| Lot Number | Product | WIP |
|---|
| 1111 | X | 30 |
| 222 | Y | 20 |
| 333 | Y | 20 |
I would like to find those products at risk where Backlog > (Inventory + WIP). In this example, for each product the calculation is:
Product X: Backlog of 90 > (Inventory of 30 + WIP of 30) --> meets the above condition, the product is at risk
Product Y: Backlog of 100 < (Inventory of 80 + WIP of 40) --> does not meet the above condition
In this case, I would like to show in chart/table only product X that matches the condition.
Today I have a table with dimension Product and a Difference measure where:
Difference = Sum(Backlog) - Sum(Inventory) - Sum(WIP)
I take this to Excel and eliminate records where Difference is lower than or equal to 0.
Is there any way in Qlik Sense to show in the table only the products that match the condition?
Regards
