topic Re: use variable as result of another variable in set analysis in QlikView

use variable as result of another variable in set analysis

curiousfellow — Sun, 06 Nov 2016 11:46:11 GMT

I have a variable as a result of another variable.

In a textbox the correct value of this variable is displayed

Now I want to use this variable in set analysis.

I think I tried every possible syntax but nothing works.

When I use a number instead of this variable in set analysis I get the correct results too

What I think the syntax should be =

count(distinct {<year= {'$(vYear)}>} employees)

count(distinct {<year= {'$(=vYear)'}>} employees)

double quotes didn't help

Re: use variable as result of another variable in set analysis

sunny_talwar — Sun, 06 Nov 2016 12:02:24 GMT

How do you define vYear? May be you need a dollar sign expansion for your variable also?

Count(Distinct {<year= {"$(=$(vYear))"}>} employees)

Re: use variable as result of another variable in set analysis

curiousfellow — Sun, 06 Nov 2016 13:00:56 GMT

I will try to explain something more.

I have to listboxes , one with the dimension year

and one with the dimension year_to_compare_with

When i select year , then all periods should be selected where the enddate of the period < today()

Every period has a number, a period is a kind of a quarter but begin and enddate don't match calendar quarters. the number of a period of a period is calculated by : year*4+quarter

This period number is a field in every record.

To store the periodnumber in a variable called v_periodnumber I use a Mastercalendar table with next expression :

=max(distinct {1<MasterCalander.period_enddate = {"=max(MasterCalander.period_enddate_Educator) < vDdate_today"}>} periodnumber)

To get the periodnumber where to compare with I use another variable v_periodnumer_to_compare with the expression :

=v_periodnumber –((year-year_to_compare_with-year)*4)

Both variables show correct values in a textbox

But when I use the expression

count( distinct {1<periodnumber= {=$(v_period_to_compare)}>}employees)

I get 0 as a result

Your solution didn't give a good result neither

Re: use variable as result of another variable in set analysis

curiousfellow — Sun, 06 Nov 2016 13:41:51 GMT

problem solved, allthough I don't know what is different from the expression I used before

Re: use variable as result of another variable in set analysis

Gysbert_Wassenaar — Sun, 06 Nov 2016 14:40:14 GMT

Please mark this discussion as answered.

answered‌

resolved‌