topic Re: Trouble with variables and date selection in QlikView

Trouble with variables and date selection

Thu, 26 Jun 2014 20:59:58 GMT

I have a formula that I turned into a variable called vUsers

vUsers = count(distinct(users)

Then I have a chart where I add vUsers as an expression

when it's applied, and I use the date filters the value is displaying on all Months in my chart as well as Quarters when Quarters is selected. Not sure why since I only have 1 month of data loaded. It's the same value across all the months when I have the year selected.

Anyone know what I'm doing wrong here?

Re: Trouble with variables and date selection

Thu, 26 Jun 2014 21:02:31 GMT

Hi,

try writtning your variable (in expression) like this: $(vUsers) .

Best regards.

Re: Trouble with variables and date selection

Thu, 26 Jun 2014 21:07:02 GMT

Nope. Unfortunately same thing

Re: Re: Trouble with variables and date selection

Thu, 26 Jun 2014 21:18:22 GMT

John,

DId you declare variabe in "Variable Overview"?

if your answer is Yes... select ypur variable and delete symbol "=" then write your varible in chart $(vUser).

See the imagine

Best regards.

Re: Re: Trouble with variables and date selection

Thu, 26 Jun 2014 21:21:43 GMT

Bingo. Oswaldo. That worked. Now, why would that make a difference? Just so I understand it?

Re: Trouble with variables and date selection

Thu, 26 Jun 2014 21:43:04 GMT

Jeje to be honest... I don't know, just try and error :S (experience I guess)

Regards.