Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

mrbqlik2009
New Contributor III

Re: Run sql query with parameter

can you describe details or give me a sample?