Discussion Board for collaboration on QlikView Scripting.
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:
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?
Go to Solution.
='[' & pivotDim1 & ']'
='[' & '$(pivotDim1)' & ']'
try this instead for your calculated dimension:
Let me know how it goes and if you need me to explain how it works
The expression without the dollar sign worked!
It didn't work, but I was able to fix it by removing the dollar sign.