Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbqlik2009
Contributor III
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
Master II
Master II

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
Contributor III
Contributor III
Author

My problem is not date.

I want know how can i get result dynamically.

lorenzoconforti
Specialist II
Specialist II

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

prieper
Master II
Master II

Alternatively you may check possibilities under Dynamic Update

What is Dynamic Update in QlikView?

Peter

mrbqlik2009
Contributor III
Contributor III
Author

can you describe details or give me a sample?