Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
ashleywooldridg
Contributor II
Contributor II

Nested set analysis - dynamic selection

I have a need to get the QTY un-received for the earliest order with a un-received QTY greater than 0.

In another column on the straight table I currently get the next Order Date for this by using:

     =Min({$<[PO Unreceived QTY]={'>0'}>}[PO ETA])

I have tried to use the below to get the [PO Unreceived QTY] for the same order, but this only works when i make the selection for particular items, if not making a selection the returned value is based off all items. I have tried to include and exclude certain Tables and Fields, but this does not seem to work.

     =Sum({$<[PO ETA]={'$(=Min({$<[PO Unreceived QTY]={'>0'}>} [PO ETA]))'}>}[PO Unreceived QTY])

Is there a way to have the Min date value return the line value rather than the value based on the entire data set?

1 Solution

Accepted Solutions
sunny_talwar

May be try this

FirstSortedValue({$<[PO Unreceived QTY] = {'>0'}>} [PO Unreceived QTY], [PO ETA])

View solution in original post

2 Replies
sunny_talwar

May be try this

FirstSortedValue({$<[PO Unreceived QTY] = {'>0'}>} [PO Unreceived QTY], [PO ETA])

View solution in original post

ashleywooldridg
Contributor II
Contributor II
Author

Thank you Sunny, this works for what i require.