topic Re: Want to execute an SQL query on DocumentOpen in QlikView https://community.qlik.com/t5/QlikView/Want-to-execute-an-SQL-query-on-DocumentOpen/m-p/643540#M1084979 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Keshav,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Personally, I think that's a bad idea to run the SQL query on events and especially on "Document Open". I would rather suggest you to use QlikView Direct Discovery which fetches the data from database without reload the data from QlikView application. With new service release QlikTech enhanced the Direct Discovery functionality.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Sat, 07 Jun 2014 13:33:49 GMT IAMDV 2014-06-07T13:33:49Z Want to execute an SQL query on DocumentOpen https://community.qlik.com/t5/QlikView/Want-to-execute-an-SQL-query-on-DocumentOpen/m-p/643539#M1084978 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want to execute a select query on DocumentOpen without re-loading the file.</P><P></P><P>How can i achieve that?</P><P></P><P>Thanking in advance.</P></BODY></HTML> Sat, 07 Jun 2014 10:28:14 GMT https://community.qlik.com/t5/QlikView/Want-to-execute-an-SQL-query-on-DocumentOpen/m-p/643539#M1084978 2014-06-07T10:28:14Z Re: Want to execute an SQL query on DocumentOpen https://community.qlik.com/t5/QlikView/Want-to-execute-an-SQL-query-on-DocumentOpen/m-p/643540#M1084979 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi Keshav,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Personally, I think that's a bad idea to run the SQL query on events and especially on "Document Open". I would rather suggest you to use QlikView Direct Discovery which fetches the data from database without reload the data from QlikView application. With new service release QlikTech enhanced the Direct Discovery functionality.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I hope this helps!</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Sat, 07 Jun 2014 13:33:49 GMT https://community.qlik.com/t5/QlikView/Want-to-execute-an-SQL-query-on-DocumentOpen/m-p/643540#M1084979 IAMDV 2014-06-07T13:33:49Z