topic Re: Changing The Edit Script after Reloading the Data. in QlikView

Changing The Edit Script after Reloading the Data.

Fri, 22 May 2015 18:49:47 GMT

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.

Re: Changing The Edit Script after Reloading the Data.

Anonymous — Sat, 23 May 2015 17:44:49 GMT

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

Re: Changing The Edit Script after Reloading the Data.

Gabriel — Sat, 23 May 2015 18:53:15 GMT

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.

Re: Changing The Edit Script after Reloading the Data.

Sat, 23 May 2015 18:59:07 GMT

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

Re: Changing The Edit Script after Reloading the Data.

Gabriel — Sat, 23 May 2015 19:22:19 GMT

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.

Re: Changing The Edit Script after Reloading the Data.

ToniKautto — Sun, 24 May 2015 00:15:08 GMT

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.

Re: Changing The Edit Script after Reloading the Data.

Wed, 27 May 2015 07:54:12 GMT

Thanks a lot to everyone..Very helpful indeed!

Re: Changing The Edit Script after Reloading the Data.

Gabriel — Wed, 27 May 2015 07:56:52 GMT

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

Re: Changing The Edit Script after Reloading the Data.

Wed, 27 May 2015 08:00:09 GMT

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

Re: Changing The Edit Script after Reloading the Data.

petter — Wed, 27 May 2015 09:20:07 GMT

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.

Re: Changing The Edit Script after Reloading the Data.

timanshu — Wed, 27 May 2015 10:41:51 GMT

Kindly mark most helpful reply as answer. It will help others to find the answer of what they look for.