topic Re: Reload option in QlikView

Reload option

brindlogcool — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have gone through the some of the post in the community as there is an option to preload the document in the memory using batch files so that it will be faster when user is accessing the file in the accesspoint. The post has given clearly the preload option just loads the unaggregated data not the UI and other aggregations. we need to create a batch script to do it.

It would be appreciated if somebody share the knowledge.

Reload option

rwunderlich — Thu, 19 Jan 2012 19:12:15 GMT

http://iqlik.wordpress.com/2011/09/11/power-up-your-big-apps-with-binary-index-expansion/

Reload option

brindlogcool — Thu, 19 Jan 2012 19:48:47 GMT

Hi Rob,

Gone through your blog it was really good.

Reload option

brindlogcool — Thu, 19 Jan 2012 20:38:29 GMT

Any suggestions how to do it in vbscript.

Reload option

rwunderlich — Thu, 19 Jan 2012 20:50:30 GMT

Thanks for the compliment but iqlik is not my blog. My blog is http://qlikviewnotes.blogspot.com/.

-Rob

Reload option

brindlogcool — Thu, 19 Jan 2012 20:59:52 GMT

Is there any way i can do it in vb script

Reload option

rwunderlich — Thu, 19 Jan 2012 23:09:54 GMT

I think you can open the document from server using a QVP link. And then iterate through the sheets and objects to make sure everything becomes visible and is calculated. You could steal lots of the necessary code from DocumentAnalyzer at http://robwunderlich.com/downloads

-Rob

Reload option

brindlogcool — Fri, 20 Jan 2012 20:07:53 GMT

Thanks Rob,

if my understanding is correct i will acess the url through the script and run through tabs to preload in to memory. So there will be session restriction as the loaded will be no longer when session is lost.Also license usage. How to address this issue.

Any suggestions.

Reload option

rwunderlich — Sat, 21 Jan 2012 19:49:43 GMT

The session that runs the script will need a license. However, you can end the session and the document will remain as long as the the document timeout setting.

-Rob

Re: Reload option

brindlogcool — Tue, 24 Jan 2012 20:42:10 GMT

Thanks Rob,

I am able to use the script and open the file to put into memory. But while running the script the application is opened. Is there any way i can hide it .

Reload option

rwunderlich — Wed, 25 Jan 2012 03:18:26 GMT

I don't know of any way to keep the document from being visible.

-Rob

Re: Reload option

brindlogcool — Wed, 25 Jan 2012 15:06:31 GMT

Thanks Rob you gave me a starting point , Any have the actual requirement of using the script to put the QVW into memmory is done from the starting point you have provided.