Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 ?

Tags (1)
Labels (1)
4 Replies
chandashok
Contributor III

choosing date by users before reload

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

chandashok
Contributor III

choosing date by users before reload

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

choosing date by users before reload

Thank you chandashok,

 

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

Many thanks.

Not applicable

choosing date by users before reload

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 ?

Community Browser