topic using variables in set analysis in QlikView

using variables in set analysis

Fri, 26 Apr 2013 13:43:29 GMT

Hi there,

I have a variable (v_on_season) that calculates the number of thansactions that a customer performs in a selected period , eg Q1 2012. and another variable (v_off_season) that calculates the number of thansactions that a customer performs in another selected period , eg Q4 2012.

I want to calculate the number of customers that performed at least one transaction in the first period and at least 100 in the other selected period.

So if customer_id is the calculated field i want to calculate something like this:

count ( {$< $(v_on_season) > 0 , $(v_off_season) >= 100>} customer_id)

Any help would be very appreciated.

Thank you in advance.

Re: using variables in set analysis

Anonymous — Fri, 26 Apr 2013 18:02:06 GMT

Try this, without set analysis:

count(distinct if(aggr($(v_on_season),customer_id)>0 and aggr($(v_off_season),customer_id)>=100, customer_id))

I can't be sure if I got it right without knowing the nature of your variables. In this case I assume that they are text of expressions rather than result of expressions calculations.

Regards,

Michael

Re: using variables in set analysis

nilesh_gangurde — Fri, 26 Apr 2013 18:50:30 GMT

Hi dimcharalampou

the variable will store only one value hence you cant calculate for each customer.

please share the logic, how u are calculating those variables.

-Nilesh

Re: using variables in set analysis

sushil353 — Sat, 27 Apr 2013 01:52:52 GMT

Hi,

Try this:

if($(v_on_season)>0 and $(v_off_season) >= 100,count(customer_id))

if it is not working then please share the logic to implement the set analysis.

HTH

Sushil

Re: using variables in set analysis

Mon, 29 Apr 2013 07:44:46 GMT

Hi there,

The variable for on season is : count({$< Season = p[Season1] >} [Transaction Ammount])

and for off season is: count({$< Season = p[Season2] >} [Transaction Ammount])

Thank you all for your responses guys!

Re: using variables in set analysis

Wed, 08 May 2013 13:51:17 GMT

Hi there,

Any suggestions?

Thank you.

Re: using variables in set analysis

anandathome — Wed, 08 May 2013 15:02:41 GMT

Hi,

Please try this example.

As rightly said by Nilesh, you can not achieve it by variables.

Try this one and see if it helps