Discussion board where members can get started with QlikView.
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.
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
My problem is not date.
I want know how can i get result dynamically.
You could have an action against setting the dates which triggers a partial reload
Alternatively you may check possibilities under Dynamic Update
What is Dynamic Update in QlikView?
can you describe details or give me a sample?