Hi,
I need to help to export variables using load script in qlikview.
I have created variable table in excel and I am calling it in qlikview load script as below
LOAD Variable,
Value
FROM
Variable.qvd
(ooxml, embedded labels, table is Sheet1);
FOR i=0 TO NoOfRows('Variables')
LET vVar = Peek('Variable', $(i), 'Variables');
LET vVal = Peek('Value', $(i), 'Variables');
LET '$(vVar)' = '$(vVal)';
NEXT
Now my variables are now available in Settings>Variable Overview after executing above script.
Input boxes are now used for the user to change these variable values.
My question is how can I export these variables after user has changed the values in the input box?
For eg: my default value for vA is 0.1 and now user has changed it to 0.5 in input box
My Variable.qvd should now show the new values (for vA it should be 0.5) instead of old values(0.1)
Can i get some lead here ?