QlikView - Use a variable into set analysis expression

Question

I've the variable varCurrentYear

varCurrentYear = Year(Today())

And I wrote this set analysis expression

Expression

The result it’s not correct. By the way If the variable is declared in this way

varCurrentYear = 2014

The result is correct.

Why? Thank's

score 3 · Answer 1 · answered Feb 23 '14 at 13:07

3

I'd use

Sum({$<Year={'$(varCurrentYear)'}>}Orders)

resp without quotes if varCurrentYear is numeric

Sum({$<Year={$(varCurrentYear)}>}Orders)

Regards Stefan

answered Feb 23 '14 at 13:07

Stefan Walther

Hi Stefan, I have the same problem and I have tried your tips and the set Analysis generator. but it does not worked. May you please have a look on my question which I have just asked. http://stackoverflow.com/questions/37411577/using-variables-in-set-analysis-expressoin – Ziad Salem May 24 '16 at 11:00

score 3 · Answer 2 · answered Oct 30 '14 at 15:35

3

I know it looks strange, but you have to write:

=sum({<Year={"$(=$(varCurrentYear))" } >} Orders)

The QlikView parser can evaluate the double-nested variable for some reason.

answered Oct 30 '14 at 15:35

user1141785

score 0 · Answer 3 · answered Jan 14 '15 at 17:21

0

I'd use:

=Sum({<Year={$(=varCurrentYear)}>}Orders)

answered Jan 14 '15 at 17:21

Agustín Palacios

How is this different than @stefan's answer? – BlargleMonster Jan 14 '15 at 17:45

3 Answers3