Execution of a query on DocumentOpen

[#1]

Hi all,

I want to execute a select query on DocumentOpen without re-loading the file.

How can i achieve that?

Thanking in advance.

[Gysbert_Wassenaar]

Create a vbscript macro to create a connection to a database and execute your query. You can use the OnOpen document trigger to execute the macro. Note that you cannot use this method to add data to your qlikview document. If you want to do that you will have to use a reload or a partial reload.

[#3]

Hi Gysbert,

Thanks for answering.

I got the point that i cannot use the macro's output in qlikview file.

I just want to know about using partial load for this.

How can i use partial load for this.

thanks in advance.

[#4]

Or you may help me in writing custom function inside which i may call the script and use as a text object's caption.