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: 
dominic_marchan
Contributor III
Contributor III

First data with positive value

Hi all,

I am trying to show the first date we are going to be receiving inventory and the quantity.

 

for:

ModelWarehouseDateQuantity
A11/1/20200
A11/2/202012
A21/3/2020250
A21/4/20200

 

 

I would like the Qlik table to show

 

ModelWarehouseDateQuantity
A11/2/202012
A21/3/2020250

 

I included test data for you guys to play with.

Thanks for the help!!!!

Labels (2)
1 Solution

Accepted Solutions
Or
MVP
MVP

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)

View solution in original post

1 Reply
Or
MVP
MVP

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)