topic Nested Set Analysis Question in QlikView https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Question/m-p/257466#M711336 <HTML><HEAD></HEAD><BODY><P>=min({$&lt; OrdDate = {'$(=min({$0'}&gt;} OrdDate))'} &gt;} [OrdLine])</P></BODY></HTML> Mon, 08 Aug 2011 21:31:20 GMT 2011-08-08T21:31:20Z Nested Set Analysis Question https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Question/m-p/257465#M711335 <HTML><HEAD></HEAD><BODY><P>Hi, I'd appreciate if someone could give this a look: My goal is to display the OrdLine associated with the Minimum OrdDate that has an Open Qty &gt; 0 =min({$&lt; OrdDate = {'$(=min({$0'}&gt;} OrdDate))'} &gt;} [OrdLine]) But the above doesn't work. Any thoughts ? Thanks - Tim</P></BODY></HTML> Mon, 08 Aug 2011 21:30:11 GMT https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Question/m-p/257465#M711335 2011-08-08T21:30:11Z Nested Set Analysis Question https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Question/m-p/257466#M711336 <HTML><HEAD></HEAD><BODY><P>=min({$&lt; OrdDate = {'$(=min({$0'}&gt;} OrdDate))'} &gt;} [OrdLine])</P></BODY></HTML> Mon, 08 Aug 2011 21:31:20 GMT https://community.qlik.com/t5/QlikView/Nested-Set-Analysis-Question/m-p/257466#M711336 2011-08-08T21:31:20Z