topic Script failed storing input field on partial load in QlikView

Script failed storing input field on partial load

mrossoit — Thu, 02 Apr 2015 14:34:47 GMT

Hi all,

I'm trying to build a save/load "macro-less" system for values modified by a user.

My app loads many records so I used partial load to execute only the storing portion of the script.

In the sample you could see that if inputfield declaration is commented then the qvd's saving process works, in the opposite a loading error occurs.

Any of you knows if this is caused by a qlikview bug or if I missed something?

Thanks

Re: Script failed storing input field on partial load

pokassov — Thu, 02 Apr 2015 14:49:27 GMT

Hello, Massimiliano!

Please, change your script. Because you have a mistake in "store.." section.

INPUTFIELD IF;

tab:

LOAD * INLINE [

F1, IF

1, 0

2, 0

3, 0

];

if IsPartialReload() then

STORE tab into tab.qvd (qvd);

ENDIF;

Re: Script failed storing input field on partial load

mrossoit — Thu, 02 Apr 2015 14:59:55 GMT

Hi Сергей,

thank you for your answer but partial load still not work on my qvw

Re: Script failed storing input field on partial load

pokassov — Thu, 02 Apr 2015 15:52:36 GMT

I'm sorry. My first answer was wrong.

It's curious. It's looks like qv sees the table "tab" but cannot use it during partial reload.

So I decided to try some tricks.

One of them have worked. I created another table and store it to qvd;

Can you try?

INPUTFIELD IF;

tab:

LOAD * INLINE [

F1, IF

1, 0

2, 0

3, 0

];

if IsPartialReload() then

//STORE tab into c:\temp\tab.qvd (qvd);

let vChech=NoOfTables();

TRACE $(vChech);

t2:

Replace NoConcatenate

LOAD

Resident

tab;

STORE t2 into c:\temp\tab.qvd (qvd);

DROP Table t2;

ENDIF;

Re: Script failed storing input field on partial load

mrossoit — Thu, 02 Apr 2015 16:03:01 GMT

Same result.

The document automatically close during script execution and qv ask me if I want to load previous data

Re: Script failed storing input field on partial load

pokassov — Thu, 02 Apr 2015 16:39:07 GMT

It's strange...

Now I'm sure with the result. I've attached model.

Can you check your QlikView version?

Sergey

Re: Script failed storing input field on partial load

mrossoit — Fri, 03 Apr 2015 10:11:41 GMT

Loading tab in a temporary t2 is a good idea.

Your qvw now doesn't crash during partial load but has a strange behaviour:

after the storing, IF becomes a normal field without input functionality and its values automatically change from 0, 0, 0 to 0, 1, 2 in this order.

Yesterday I was running 11.20.12235.0 SR5 x64 version, this morning I installed 11.20.12742.0 SR10 x64 version but there's no differences.

Re: Script failed storing input field on partial load

pokassov — Fri, 03 Apr 2015 14:34:39 GMT

I've break my head ))

Instead of partial reload I used the action "Export".

I had got the file with correct inputfield values.

And my inputfield still was inputfield.

After that I changed some inputfield values.

However, when I was traying load this file (instead of load * inline), inputfield values didn't change.

Sergey.

Re: Script failed storing input field on partial load

sunny_talwar — Fri, 03 Apr 2015 14:39:52 GMT

Did not go through the whole post, but Partial Reload needs Add or Replace next to LOAD. Is that something which might be missing?

I am going to check now.

Best,

Sunny

Re: Script failed storing input field on partial load

sunny_talwar — Fri, 03 Apr 2015 14:42:25 GMT

I guess you are only trying to save it during the partial reload. So that doesn't need an Add or Replace. My bad.

Best,

Sunny

Re: Script failed storing input field on partial load

mrossoit — Sun, 05 Apr 2015 16:35:23 GMT

Inputfield values didn't change after load from qvd because the qvw remember the changes until you remove all data.