Discussion Board for collaboration on QlikView Scripting.
I would like to know is it possible to use variable as a field name during the loading?
let vFieldName = 'aaabbb'
Description as $(vFieldName)
Thanks for your help!
Go to Solution.
Yes. Variables are very flexible in QlikView, in expressions and load script. Believe it or not the following will work...
let vFieldName = 'tion as Fie';
The syntax highlighting will have a wobbler, but you just have to think of dollar sign expansion as copying and pasting the contents of the variable into the location where you do the DSE.
Hope that makes sense.
Yes it is certainly possible and works.
Just make sure you have a semicolon after the let statement and a comma after the dollar expansion.
It works perfectly.
Thanks for your reply. I missed the semicolon only from the post. I tried to passed the variable to the fieldname as $(vFieldName)&'_xy' instead of $(vFieldName)_xy. Now it works.