topic Re: Evaluating Variable within another Variable in QlikView

Evaluating Variable within another Variable

Fri, 20 Jun 2014 15:36:20 GMT

I have a chart where the user selects the dimension from an input box. For dimensions that are more than one word, the dynamic chart doesn't work because I need brackets around the name:

Example:

If the user selects Target Line, I need to pass [Target Line].

I created a new variable using the code:

='[' & $(pivotDim1) & ']'

But this only returns [] without the selected dimension between brackets. My pivotDim1 variable works fine for reading the selected name, so this variable is not the problem. Any suggestions?

Re: Evaluating Variable within another Variable

swuehl — Fri, 20 Jun 2014 16:22:32 GMT

Try

='[' & pivotDim1 & ']'

edit:

='[' & '$(pivotDim1)' & ']'

Re: Evaluating Variable within another Variable

Anonymous — Fri, 20 Jun 2014 16:25:16 GMT

Hi Andy,

try this instead for your calculated dimension:

= $(='['&only(pivotDim1)&']')

Let me know how it goes and if you need me to explain how it works

Boris

Re: Evaluating Variable within another Variable

Fri, 20 Jun 2014 17:17:15 GMT

The expression without the dollar sign worked!

Re: Evaluating Variable within another Variable

Fri, 20 Jun 2014 17:20:03 GMT

It didn't work, but I was able to fix it by removing the dollar sign.