topic Re: how to assign value to Inputfield in the script? in QlikView

how to assign value to Inputfield in the script?

Thu, 31 Jul 2014 14:09:34 GMT

I have 6 inputfields, after the user's entered the data, the values are saved in an excel file.

Whenever I add new data to my data model and do a reload, all the values of the input fields are reset to 0, so I need a way to give the user the values that they had entered.

Is there a way to load the excel sheet data and assign the values to specific inputfields on reload/ in the script?

Please its very urgent, any help in this will be greatly appreciated.

Thanks

Re: how to assign value to Inputfield in the script?

alexandros17 — Thu, 31 Jul 2014 14:12:49 GMT

Assign in the script the values from the excel to the variables used for the input field

Re: how to assign value to Inputfield in the script?

Thu, 31 Jul 2014 14:17:21 GMT

Thanks for the quick response, can you please provide me with an example, I am kinda a newbie.

Re: how to assign value to Inputfield in the script?

Thu, 31 Jul 2014 14:20:12 GMT

BTW, the inputfield doesnt like it when I assign a variable to it.

say for example:

LET vExcelValue=154;

in the pivot table under the expressions table : InputSum($(vExcelValue)) ... it gives me a '-' hypen