topic Set Analysis with function Variable in QlikView

Set Analysis with function Variable

Anonymous — Thu, 06 Dec 2012 15:21:31 GMT

Hi everyone,

Is it possible use set analysis with function Variable.

Other words,

vVar1=sum(Variable)

in expression: sum({<Variable2={'...'}>} vVar1)

Thanks,

Re: Set Analysis with function Variable

dt_g_tsar — Thu, 06 Dec 2012 16:36:16 GMT

Hello Vladimir,

You can indeed. Just make sure that your variable holds the expression without a '=' if you are defining it in Settings-Variable Overview and inside single quotes if you define in the loading script.

vVar1='sum(Variable)';

You then refer to it in your expression in the following manner.

sum({<Variable2={'...'}>} $(vVar1))

George

Re: Set Analysis with function Variable

vgutkovsky — Thu, 06 Dec 2012 16:37:34 GMT

If I understand you correctly, you're asking if it's possible to separately store the expression variable and the set analysis variable. Indeed it is, and it makes life a lot easier in terms of management. However, you can only assign a field value in set analysis, not a variable value. So something like this:

vVar1 (make sure this does not start with an = sign)

sum($(vVar2) myfield)

vVar2 (make sure this does start with an = sign)

='{<' & 'myfilter={' & chr(39) & 'ABC' & chr(39) & '}>}'

Expression

$(vVar1)

Hope this helps,

Vlad

Re: Set Analysis with function Variable

Anonymous — Thu, 06 Dec 2012 17:41:27 GMT

Hi Vlad,

Thank for your help.

I have expression like this

myVar:

Round ((Count({<[Overall experience]={'9-10'}>}[Overall experience])-Count({<[Overall experience]={'0-6'}>}[Overall experience]))/

count(TOTAL [Overall experience]),0.001)*100

I want to use it depended on variable-Country.

round(SET ANALYSIS Country) myVar)

I think conditional and myVar don`t work together.

Am I right

Regards,

Re: Set Analysis with function Variable

vgutkovsky — Thu, 06 Dec 2012 19:58:07 GMT

How about something like this:

Round ((Count({<[Overall experience]={'9-10'},Country={$(vCountry)}>}[Overall experience])-Count({<[Overall experience]={'0-6'},Country={$(vCountry)}>}[Overall experience]))/

count({<Country={$(vCountry)}>}TOTAL [Overall experience]),0.001)*100

This assumes that your field is called Country and your variable that contains the relevant country is called vCountry.

Vlad

Re: Set Analysis with function Variable

Anonymous — Thu, 06 Dec 2012 20:15:20 GMT

It should work.

the question was possible to use Variable and SET ANALYSIS.

I think it doesnt work

Thanks,

Re: Set Analysis with function Variable

vgutkovsky — Thu, 06 Dec 2012 20:19:19 GMT

You're right, you can't pass set analysis into a variable while evaluating the variable as an expression because the expression $(myVar) is already an evaluation. But the solution above should work just as well.

Regards,

Vlad

Re: Set Analysis with function Variable

Anonymous — Thu, 06 Dec 2012 21:01:10 GMT

Thank you for confirmation