Nested set analysis - dynamic selection

ashleywooldridg — Tue, 12 Jun 2018 00:02:42 GMT

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?

Re: Nested set analysis - dynamic selection

sunny_talwar — Tue, 12 Jun 2018 02:34:13 GMT

May be try this

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

Re: Nested set analysis - dynamic selection

ashleywooldridg — Tue, 12 Jun 2018 03:49:02 GMT

Thank you Sunny, this works for what i require.

topic Re: Nested set analysis - dynamic selection in QlikView

Nested set analysis - dynamic selection

Re: Nested set analysis - dynamic selection

Re: Nested set analysis - dynamic selection