Changing The Edit Script after Reloading the Data.

[#1]

I am working on a document which has 3 tables in the Edit Script. After the initial reloading,I could observe that the modelling is not correct in Table view and now need to change one of the table details within Edit Script.After making that change,I would be needing to reload once again but want to make sure it doesn't double load the data for other 2 tables too..How do I make sure that during the second reloading ( after fixing that specific table) it doesn't mess up the document.

[Anonymous · Accepted solution]

The reload will purge all data held in RAM tables and reloads it all again so no data will be doubled up..

[Gabriel]

Hi,

If you are reloading the presentation layer (that is the main App) the data will not double up. Just imagine that QlikView will delete whatever it has loaded before and bring in same data again. Simple put no QV will not double the data.

[#4]

Thanks a lot!So to make sure that no double data load I need not to click or check any specific box right..it's just a basic behavior of Qlikview not to double load but every time delete and do a complete new loading.

Sent from my iPhone

[Gabriel]

Hi,

Yes so long as you're not doing incremental load. If it's normal load then yes no double data.

What you can do for checking is just do a count of the unique key in a textbox. Then check if the number change after reload.

[ToniKautto]

During reload data is retrieved from the source and the data model is stored in memory. Note, the data is not necessarily stored to disk.

In QlikView Desktop client this means that you need to initiate a Save to get the data stored into the QlikView Application (QVW) file. This can be done manually or by enabling automatic save after reload.

In QlikView server the data is automatically stored to QVW file after a successful reload.

[#7]

Thanks a lot to everyone..Very helpful indeed!

[Gabriel]

Hi,

So what's the update regarding your question.

Did 1 of the answer provided solve your problem of helpful?

Please give update just for someone else who might have similar issue

[#9]

This was more for conception as I was doing some labs.The detail answers clear my concept on how the reload works.

[petter]

You should mark the Question as answered anyway - giving the people that contributed some recognition is being polite and respectful of their time and effort.