Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
ashleywooldridg
New 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
Highlighted

Re: Nested set analysis - dynamic selection

May be try this

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

View solution in original post

2 Replies
Highlighted

Re: Nested set analysis - dynamic selection

May be try this

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

View solution in original post

Highlighted
ashleywooldridg
New Contributor II

Re: Nested set analysis - dynamic selection

Thank you Sunny, this works for what i require.