topic Re: Variable in Set Analysis in QlikView

Variable in Set Analysis

Wed, 06 May 2015 08:01:46 GMT

Guys,

I have a variable as follows:

vCurMonth=num(Month(Today()))

I want to use this variable within my expression in the table:

Sum({<Months={$(vCurMonth)}>}Allocations)

But it's not working.

Any ideas?

jonathandienst — Wed, 06 May 2015 08:11:56 GMT

Is your Months field numeric? The variable definition needs a leading = sign (in Variable Overview). So vCurMonth should be:

=Month(Today())

=Num(Month(Today())

HTH

Jonathan

Wed, 06 May 2015 08:14:44 GMT

Hi,

It works perfectly in calculated dimension, but this variable isnt working in Set Analysis in expression. I guess, there's no problem with formats