topic choosing date by users before reload in QlikView

choosing date by users before reload

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

Is it possible to give users possibility to choose date by themself. After choosing date they will reload data - and get required data.

For example I have report with two dates. I want before reload user with thin client choose date and then reload this file.

Is it possible and how to do it ?

Anonymous — Tue, 06 Mar 2012 08:36:50 GMT

Ya it is possible to choose the date before the reload from the qv file and reload using the variable in the qv

script.

just create the varialbe in the script and use that variable in the qv sheet and assign the value of user

selected date into that variable and reload it

Regards

Ashok

Anonymous — Tue, 06 Mar 2012 08:40:22 GMT

example

Let vClientSelectedDate= $(variableName); holds the client selected date value

EmployeeDetails:

SQL SELECT

"Emp_name",

"Emp_Sal",

"Audit_Action",

"Audit_Timestamp_ChangedDetails"

FROM dbo.Employee_Test_Audit

WHERE Audit_Timestamp_ChangedDetails >= $(vClientSelectedDate);

Tue, 06 Mar 2012 08:44:34 GMT

Thank you chandashok,

I am trying do it. I will inform you about results.

Many thanks.

Tue, 06 Mar 2012 12:17:13 GMT

Dear chandashok,

I wrote this:

Let vClientSelectedDate= $(variableName);

SQL SELECT *

FROM "BS_DWH_DS".CUSTOMER

WHERE date >= $(vClientSelectedDate);

But when I made reload I got the follow error:

SQL error: ORA-00936: missing expression

Script line: SELECT * FROM "BS_DWH_DS".CUSTOMER WHERE date >=

SQL SELECT *

FROM "BS_DWH_DS".CUSTOMER

WHERE date >=

Please advice what is the wrong ?

Could you send me one example file ?