How to define dimension for a variable

Tue, 08 Jul 2014 17:00:05 GMT

Hi everyone,

I'm quite new and need some help understanding the behavior of a variable in a straight table

This expression works as expected when it is used directly in my chart (return a 'Y' or 'N' correctly for that row in the cart):

=If(Mod([Ask Amount],25) = 0, 'Y','N')

However, I attempted to create a variable for this expression, v25 = If(Mod([Ask Amount],25) = 0, 'Y','N') , so could reference this expression in a few different charts, and it when I do so, it returns 'N' for all rows. I believe this is happening because it is calculating based on the sum of all rows, rather than by the dimension I have selected in my chart. Is there a way to embed a dimension in this expressions so I can use this as a variable?

Thanks,

Grace

Re: How to define dimension for a variable

rwunderlich — Tue, 08 Jul 2014 17:09:38 GMT

Make sure you define the variable without an "=" in the contents.

Then use the variable in a chart expression like:

$(v25)

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: How to define dimension for a variable

Tue, 08 Jul 2014 17:57:47 GMT

Perfect! Thanks!

topic Re: How to define dimension for a variable in QlikView

How to define dimension for a variable

Re: How to define dimension for a variable

Re: How to define dimension for a variable