Replace Values in INPUTFIELD Through Partial Reload

[mbespartochnyy]

Hello everyone,

I'm facing a challenge replacing values in a table. The task is simple:

• During full reload table loads with null values in fields Input_Value 1 through 5
• Then, in real life, users get data in a separate spreadsheet that is then transformed to look like Manual_Input table (see attached QVW)
• Once transformation is complete and the table with data to be loaded looks like the original data, partial reload is executed to replace null values with whatever values have been entered (See Populated tab in attached spreadsheet)
• A partial reload is executed and, ideally, Manual_Input table would have the values replaced with whatever user populated in the spreadsheet.

I wrote a script to load null values and a partial reload script to replace values, but when I execute a partial reload, fields Input_Value1 to 5 are populated with 0 through 75 instead of actual values that user has entered. Has anyone faced this before or knows how to solve this?

Thanks,

Mikhail Bespartochnyy

[sunny_talwar]

The only way I can think of is to use a Macro

how to reset input field values using macro | Qlik Community

Since this will be used locally, I am guessing Macro should not be a problem...

[sunny_talwar]

Was not able to make this work with Macro also.... will give it another try today... lets see if I can achieve more with a fresh mind today

[mbespartochnyy]

I gave up on it for now, added it to backlog to research later. Users didn't seem to mind. I'll keep this question open in case I'll ever find a solution. Thanks for all the suggestions, Sunny!