QlikView - using a variable in an expression for analysis

Question

I have a varCurrentYear variable

varCurrentYear = Year(Today())

And I wrote this expression for analysis

Expression

The result is not correct. By the way, if a variable is declared this way

varCurrentYear = 2014

The result is correct.

Why? Thanks x

+3

Jaep Feb 21 '14 at 13:30

3 answers

Stefan walther · Answer 1 · 2014-02-23T13:07:37+0000

I would use

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

resp without quotes if varCurrentYear is numeric

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

Relationship stefan

user1141785 · Answer 2 · 2014-10-30T15:35:30+0000

I know this looks weird, but you need to write:

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

The QlikView parser may for some reason evaluate a double nested variable.

Agustín Palacios · Answer 3 · 2015-01-14T17:21:44+0000

:

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