Run sql query with parameter

[mrbqlik2009]

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.

[prieper]

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]

My problem is not date.

I want know how can i get result dynamically.

[lorenzoconforti]

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

[prieper]

Alternatively you may check possibilities under Dynamic Update

What is Dynamic Update in QlikView?

Peter

[mrbqlik2009]

can you describe details or give me a sample?