Discussion Board for collaboration related to QlikView App Development.
Is it possible to achieve the following:
1. Set a variable in the script
2. Define the variable as a value in Excel field
3. Load the field from Excel and have the variable's value for that field?
Go to Solution.
This should work
If([Metric Code] = 107, $(VParam2) & [Metric Name], [Metric Name])
Can you explain further with example and expected output?
So what 's the value of the variable? do you want to make this variable into a input box to make a dynamic variable or something else?
I think there is other way to make this happened, but not adding the variable into the excel.
You can define the variable(for example, vtest) to some value. And in front-end, using if function : when the Metric Code = 107, then output is vtest.
Hope it can help you.