topic Re: Embed Set Analysis into Set Analysis in QlikView

Embed Set Analysis into Set Analysis

Thu, 23 Jan 2014 11:05:02 GMT

Hi guys,

Need some help with the following:

The document attached has the data below:

ExternalDate	InternalDate	Section
20/12/2013
21/12/2013	21/12/2013	Section 21
22/12/2013
23/12/2013
24/12/2013	24/12/2013	Section 24
25/12/2013	25/12/2013	Section 25

User selects one date into ExternalDate field, for example 23/12/2013

I should get the corresponding value in Section for last possible value in InternalDate when InternalDate field should have as possible values all available values UP TO 23/12/2013.

Any help will be appreciated.

Thanks,

Aldo.

Re: Embed Set Analysis into Set Analysis

jerem1234 — Thu, 23 Jan 2014 13:23:23 GMT

Hello Aldo,

Please find attached. I ended up going with firstsortedvalue and using the p() function in set analysis. The formula I used was:

firstsortedvalue( {<ExternalDate=, InternalDate=p({1<InternalDate={"<=$(=Date(Max(ExternalDate)))"}>} InternalDate)>} Section, -InternalDate)

Let me know if this is what you are looking for.

Hope this helps!

Re: Embed Set Analysis into Set Analysis

Thu, 23 Jan 2014 14:01:49 GMT

Exactly, Thanks!