Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Get as on Date Report!

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!

1 Reply
Anonymous
Not applicable
Author

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.