topic Re: Variable in Set Analysis Question in QlikView

Variable in Set Analysis Question

Wed, 25 Jun 2014 05:39:48 GMT

Hello, could you please help me solve a problem with using a year variable in set analysis :

Firstly, I have set the year variable with following statement -

LET vYear_Current = Year(Today());

When I use this expression, I get the correct answer -

=COUNT({<'StartYear' = {'2014'}>} [EMP NO.])

When I use this, I get zero as the answer -

=COUNT({<'StartYear' = {$vYear_Current}>} [EMP NO.])

Thanks,

Wayne

Re: Variable in Set Analysis Question

sasikanth — Wed, 25 Jun 2014 05:49:45 GMT

Try some thing like this

=COUNT({<'StartYear' = {'$(=vYear_Current)'}>} [EMP NO.])

Re: Variable in Set Analysis Question

Wed, 25 Jun 2014 05:52:21 GMT

try,

=COUNT({<'StartYear' = {$(=vYear_Current)}>} [EMP NO.])

hope this helps.

regards,

Re: Variable in Set Analysis Question

its_anandrjs — Wed, 25 Jun 2014 05:56:31 GMT

Try like

=COUNT({<'StartYear' = {'$( vYear_Current )' }>} [EMP NO.])

Re: Variable in Set Analysis Question

jagan — Wed, 25 Jun 2014 06:09:42 GMT

Hi,

Try like this

=COUNT({<[StartYear] = {$(=vYear_Current)}>} [EMP NO.])

Regards,

Jagan.

Re: Variable in Set Analysis Question

Wed, 25 Jun 2014 06:13:24 GMT

Use this Expression.

=COUNT({<'StartYear' = {"$( vYear_Current )" }>} [EMP NO.])

And also check whether the variable passed is giving you correct value by removing the name of the expression and then hover on Expression in chart.

Re: Variable in Set Analysis Question

Wed, 25 Jun 2014 09:30:23 GMT

Thank you all so much for replying, really appreciate it.

5 slightly different answers, no wonder I am finding the syntax in set analysis a little challenging. Just for the record, three gave me the answer I was looking for :

=COUNT({<'StartYear' = {'$(=vYear_Current)'}>} [EMP NO.])

=COUNT({<'StartYear' = {$(=vYear_Current)}>} [EMP NO.])

=COUNT({<[StartYear] = {$(=vYear_Current)}>} [EMP NO.])

=COUNT({<'StartYear' = {$vYear_Current}>} [EMP NO.]) - my initial attempt.

It seems the = sign preceding the variable is the key.

Thanks again

Wayne