Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am Ravi, just started to work with qlik view, i am now using qlikview 9 personal Edition. I am using in the scirpt like this
Let AsOnDate = Num(today(0));
in my load statement i am filtering the query as like this
Select .....
From ...
Where AsOnDate between ....StartDate and ....EndDate;
this query is basically to find whether an employee is working with an organization as on the date provided by the user at the run time.
At the first time when i use, its fetching me all the date as on today, but while am changing the date in the input field the records were not refreshed!
What i need to do get the record to be filtered as per the input i have selected during the runtime.
Please help!
Thanks
Ravi!
Ravi,
No matter what value you assign to the AsOnDate variable by using the input field, it will be overritten by the LET statement in the script. Just remove it from the script.