Export variable table using load script

haribabugv — Wed, 25 Nov 2020 16:16:04 GMT

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)';

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 ?

topic Export variable table using load script in QlikView