First data with positive value

[dominic_marchan]

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!!!!

[Or · Accepted solution]

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)