Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to show the first date we are going to be receiving inventory and the quantity.
for:
Model | Warehouse | Date | Quantity |
A | 1 | 1/1/2020 | 0 |
A | 1 | 1/2/2020 | 12 |
A | 2 | 1/3/2020 | 250 |
A | 2 | 1/4/2020 | 0 |
I would like the Qlik table to show
Model | Warehouse | Date | Quantity |
A | 1 | 1/2/2020 | 12 |
A | 2 | 1/3/2020 | 250 |
I included test data for you guys to play with.
Thanks for the help!!!!
You should be able to get this done using FirstSortedValue(), as you suggested. Just tell your formula to ignore 0 values, e.g. If(Quantity>0,Quantity)
You should be able to get this done using FirstSortedValue(), as you suggested. Just tell your formula to ignore 0 values, e.g. If(Quantity>0,Quantity)