Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mrbqlik2009
New Contributor III

Run sql query with parameter

Hi,

I have sql query with parameter fromDate and ToDate.

I want have a table in qlikview and 2 input box for dates.

when user enter dates, run query and see result in table.

5 Replies
prieper
Honored Contributor II

Re: Run sql query with parameter

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.

You may find a help under

getting stuck in SQL WHERE = Today when date is YYYYMMDD

Peter

mrbqlik2009
New Contributor III

Re: Run sql query with parameter

My problem is not date.

I want know how can i get result dynamically.

lorenzoconforti
Contributor III

Re: Run sql query with parameter

You could have an action against setting the dates which triggers a partial reload

prieper
Honored Contributor II

Re: Run sql query with parameter

Alternatively you may check possibilities under Dynamic Update

What is Dynamic Update in QlikView?

Peter

Highlighted
mrbqlik2009
New Contributor III

Re: Run sql query with parameter

can you describe details or give me a sample?