topic Re: Run sql query with parameter in QlikView https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108484#M754591 <HTML><HEAD></HEAD><BODY><P>can you describe details or give me a sample?</P></BODY></HTML> Wed, 17 Oct 2018 13:00:05 GMT mrbqlik2009 2018-10-17T13:00:05Z Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108479#M754585 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have sql query with parameter fromDate and ToDate.</P><P>I want have a table in qlikview and 2 input box for dates.</P><P>when user enter dates, run query and see result in table.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108479#M754585 mrbqlik2009 2020-11-25T16:16:04Z Re: Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108480#M754587 <HTML><HEAD></HEAD><BODY><P>Basically no problem, but dates must be formatted in the format as needed for SQL (usually String, but as in MS-Access, may also be enclosed by '#'). This string then has to be shown in the SQL-statement as WHERE-clause.</P><P></P><P>You may find a help under</P><P><A href="https://community.qlik.com/thread/61518">getting stuck in SQL WHERE = Today when date is YYYYMMDD</A></P><P></P><P>Peter</P></BODY></HTML> Tue, 16 Oct 2018 12:25:21 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108480#M754587 prieper 2018-10-16T12:25:21Z Re: Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108481#M754588 <HTML><HEAD></HEAD><BODY><P>My problem is not date.</P><P>I want know how can i get result dynamically.</P></BODY></HTML> Wed, 17 Oct 2018 08:05:22 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108481#M754588 mrbqlik2009 2018-10-17T08:05:22Z Re: Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108482#M754589 <HTML><HEAD></HEAD><BODY><P>You could have an action against setting the dates which triggers a partial reload</P></BODY></HTML> Wed, 17 Oct 2018 08:41:44 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108482#M754589 lorenzoconforti 2018-10-17T08:41:44Z Re: Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108483#M754590 <HTML><HEAD></HEAD><BODY><P>Alternatively you may check possibilities under Dynamic Update</P><P><A href="https://community.qlik.com/thread/151142">What is Dynamic Update in QlikView?</A></P><P></P><P>Peter</P></BODY></HTML> Wed, 17 Oct 2018 11:39:22 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108483#M754590 prieper 2018-10-17T11:39:22Z Re: Run sql query with parameter https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108484#M754591 <HTML><HEAD></HEAD><BODY><P>can you describe details or give me a sample?</P></BODY></HTML> Wed, 17 Oct 2018 13:00:05 GMT https://community.qlik.com/t5/QlikView/Run-sql-query-with-parameter/m-p/108484#M754591 mrbqlik2009 2018-10-17T13:00:05Z