topic Re: Execution of a query on DocumentOpen in QlikView https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643573#M235784 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sat, 07 Jun 2014 13:10:14 GMT Gysbert_Wassenaar 2014-06-07T13:10:14Z Execution of a query on DocumentOpen https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643572#M235783 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hi all,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I want to execute a select query on DocumentOpen without re-loading the file.</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can i achieve that?</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanking in advance.</P></BODY></HTML> Sat, 07 Jun 2014 12:08:51 GMT https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643572#M235783 2014-06-07T12:08:51Z Re: Execution of a query on DocumentOpen https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643573#M235784 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Sat, 07 Jun 2014 13:10:14 GMT https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643573#M235784 Gysbert_Wassenaar 2014-06-07T13:10:14Z Re: Execution of a query on DocumentOpen https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643574#M235785 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P>Thanks for answering.</P><P></P><P>I got the point that i cannot use the macro's output in qlikview file.</P><P>I just want to know about using partial load for this.</P><P></P><P>How can i use partial load for this.</P><P></P><P>thanks in advance.</P></BODY></HTML> Sun, 08 Jun 2014 11:32:11 GMT https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643574#M235785 2014-06-08T11:32:11Z Re: Execution of a query on DocumentOpen https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643575#M235786 <HTML><HEAD></HEAD><BODY><P>Or you may help me in writing custom function inside which i may call the script and use as a text object's caption.</P></BODY></HTML> Sun, 08 Jun 2014 11:36:24 GMT https://community.qlik.com/t5/QlikView/Execution-of-a-query-on-DocumentOpen/m-p/643575#M235786 2014-06-08T11:36:24Z