Discussion Board for collaboration related to QlikView App Development.
I'm trying to create a variable within script that will then display this variable in a text box. Currently in the script I have:
SET varData_Status_Year='=[Year] & '/' & ([Year] + 1)';
(where [Year] is the year selected by the user)
The output I am trying to get is e.g. 2013/2014
But when I reload the information and look at the textbox, all I get displayed is the text =[Year] & '/' & ([Year]+1) despite assigning the variable varData_Status_Year to the textbox. It's as if the definition of the variable hasn't been evaluated.
Any ideas warmly welcome. Can I even concatenate existing fields with text to create a variable???
SET varData_Status_Year=[Year] & '/' & ([Year] + 1);
Hi use let instead of set
LET varData_Status_Year=[Year] & '/' & ([Year] + 1);
Hi Michael - just tried that and I get the same as what I was getting previously but without the single quote at the start and end.
With your suggestion Ashfaq, I just get a forward slash being displayed in the textbox.
What exactly is in your text box?
Select at least one year.
The second one of your options i.e. =varData_Status_Year
I have tried the other two options but they haven't given me what I wanted either.
I have selected one year and this doesn't change anything unfortunately.