Discussion board where members can get started with Qlik Sense.
Is it possible to set a variable name to include the current year?
set v&$(vCurrentYear)&Parm1 = .05;
I want this to evaluate to v2016Parm1=.05.
Go to Solution.
You are right. I totally misread the question. I believe the solution would be:
set v$(vCurrentYear)Parm1 = .05;
LET vMyVar = 'v' & $(vCurrentYear)& 'Parm1 = .05';
So wouldn't this create a vMyVar variable with 'v2016Parm1 = .05' as value instead of a v2016Parm1 variable with '.05' as value?
Or you just need to use $(vMyVar) in place of the whole variable in the desired expression?
The proper syntax was really getting me here and I couldn't find another post on this.
I really appreciate it.
I have one additional question about this topic: Does my variable need to be script defined? I tried defining it in the app and couldn't get it to evaluate correctly.
I don't think there is any way to use a dynamic variable name from the UI Variable Overview.
Thanks for confirming