Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

choosing date by users before reload

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 ?

Labels (1)
4 Replies
Anonymous
Not applicable
Author

Hi

     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
Not applicable
Author

Hi

     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);

Not applicable
Author

Thank you chandashok,

 

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

Many thanks.

Not applicable
Author

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 ?