Discussion Board for collaboration related to QlikView Deployment.
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 ?
Ya it is possible to choose the date before the reload from the qv file and reload using the variable in the qv
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
Let vClientSelectedDate= $(variableName); holds the client selected date value
WHERE Audit_Timestamp_ChangedDetails >= $(vClientSelectedDate);
Thank you chandashok,
I am trying do it. I will inform you about results.
I wrote this:
Let vClientSelectedDate= $(variableName);
SQL SELECT *
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 >=
WHERE date >=
Please advice what is the wrong ?
Could you send me one example file ?