topic Replace Values in INPUTFIELD Through Partial Reload in QlikView

Replace Values in INPUTFIELD Through Partial Reload

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

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

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 15:51:48 GMT

How about you try this:

IF IsPartialReload() THEN

DROP Table Manual_Input;

Manual_Input:

Add LOAD Field_Name,

Input_Value,

Input_Value2,

Input_Value3,

Input_Value4,

Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 15:52:50 GMT

That did not work....

Re: Replace Values in INPUTFIELD Through Partial Reload

mbespartochnyy — Fri, 20 Jan 2017 16:18:35 GMT

That works but it now input functionality is disabled. I tried adding INPUTFIELD in partial reload script like this:

IF IsPartialReload() THEN

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

Input_Value,

Input_Value2,

Input_Value3,

Input_Value4,

Input_Value5

FROM

[Source-Data\CorporateCard\Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

But that didn't do it either. It went back to populating 0-75 numbers.

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 16:20:41 GMT

Ya I saw that.... let me try something else....

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 16:26:33 GMT

This works

IF IsPartialReload() THEN

DROP Table Manual_Input;

Manual_Input:

Add LOAD Field_Name,

Input_Value,

Input_Value2,

Input_Value3,

Input_Value4,

Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

Input_Value,

Input_Value2,

Input_Value3,

Input_Value4,

Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

ENDIF;

Re: Replace Values in INPUTFIELD Through Partial Reload

mbespartochnyy — Fri, 20 Jan 2017 17:05:12 GMT

That makes no sense to me but it worked...partially. I did a full reload then a partial reload with that script and it didn't work for me at first (populated 0-75 again). Then I commented out second portion of the partial reload script, this one:

DROP Table Manual_Input;

INPUTFIELD Input_Value;

INPUTFIELD Input_Value2;

INPUTFIELD Input_Value3;

INPUTFIELD Input_Value4;

INPUTFIELD Input_Value5;

Manual_Input:

Add LOAD Field_Name,

Input_Value,

Input_Value2,

Input_Value3,

Input_Value4,

Input_Value5

FROM

[Replace Load.xlsx]

(ooxml, embedded labels, table is Populated);

and did a partial reload. It populated values and removed the input functionality. Then I uncommented the second portion, did a full reload, and then partial reload and it populated the table with correct values and the input functionality was working. Both full and partial reloads after that worked as expected until I change the values in the excel spreadsheet. For example, changing any of the location names in the spreadsheet and then doing full and partial reload still loads the original location names.

Mikhail

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 17:13:46 GMT

I am confused.... can you repeat... I wish I could have just walked over to your desk

Re: Replace Values in INPUTFIELD Through Partial Reload

mbespartochnyy — Fri, 20 Jan 2017 17:21:22 GMT

haha I can't describe how much I miss those days. Basically, if you change a location name or any of the values in the spreadsheet, then do a partial reload, the new values are not pulling in.

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 17:29:34 GMT

Checking now...

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Fri, 20 Jan 2017 19:34:43 GMT

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...

Re: Replace Values in INPUTFIELD Through Partial Reload

sunny_talwar — Sat, 21 Jan 2017 15:34:40 GMT

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

Re: Replace Values in INPUTFIELD Through Partial Reload

mbespartochnyy — Tue, 31 Jan 2017 16:36:50 GMT

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!