topic variable + field name in QlikView

variable + field name

Wed, 07 Mar 2012 19:56:40 GMT

Hi All,

I have 2 field : Dollar_us and Dollar_ca.

I want to create a variable and set the variable( ie: location => (ca or us) ) to switch between this two field.

What I want to know is that how to add the variable to the end of filed? means : Dollar &location ????

Thanks

erichshiino — Wed, 07 Mar 2012 20:17:22 GMT

Hi,

You can use

=Dollar_$(var) as a calculated dimension instead of a regular dimension.

I create a small sample with the same functionality

hope this helps,

Erich

Wed, 07 Mar 2012 20:28:38 GMT

Thanks,

I was using the regular dimension instead of the calculated one.That's why I was getting the error message.

Thu, 18 Apr 2013 19:43:09 GMT

Cool