Using E or P set analysis with a second qualifier

Wed, 27 Aug 2014 15:31:50 GMT

Hello all,

I am trying to calculate a function that lists all subscription orders (directory_qualifier in my example), where the order doesnt exist in any later period (i.e. the subscription is ending) but has also appeared in at least 12 previous periods. I have identified orders that are ending using E set analysis as below:

count({$<directory_qualifier =E({1<Financial_Period_YYYYMM={'>$(vSelectedPeriod)'}>})>} distinct directory_qualifier)

I have also been able to count how many periods the subscription appeared in using the below:

count({$<Financial_Period_YYYYMM = {'*'}>} directory_qualifier)

I'm struggling to bring the two together though, to give me a result set of subscriptions which have run for 12 period and finish in the selected period (vSelectedPeriod). Is this possible through just set analysis, or through a combination of if statement and set analysis?

Many thanks in advance for your help.

Noel

topic Using E or P set analysis with a second qualifier in QlikView

Using E or P set analysis with a second qualifier