Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My qlikview report has a query which has a WHERE condition that contains date & time.
I want this report to get reloaded automatically in every 6 hours with fresh date & time parameters ( this date and time parameter will be using OS date & time).
Is it possible to do that?
Thanks!
Hi
You have two options;
Firstly, load a variable in your script such as;
Let xxx = now();
This will create a timestamp. Then simply take 6 hrs off it - now() - 0.25 (0.25 as 6hrs is a quarter of a day). This will provide you with the time 6hrs ago and you need to load anything created after that by using this where clause at the end of your load;
where createdstimestamp > xxx
However, loads may fail and therefore you miss a 6hr period. I would recommend you load the now variable at the end of your load and save this variable into the qvw. Then your next load can read when the last load completed and load anything after that - even if load(s) fail and more than 6hrs need loading.
Does that answer your question?
Let me know how you get on.
Regards
Steve
Nobody knows about it?
You can always use Date() function in a where clause of load scipt in qv. But what you want should be handled using QV Publisher or Windows scheduler.
Hi
You have two options;
Firstly, load a variable in your script such as;
Let xxx = now();
This will create a timestamp. Then simply take 6 hrs off it - now() - 0.25 (0.25 as 6hrs is a quarter of a day). This will provide you with the time 6hrs ago and you need to load anything created after that by using this where clause at the end of your load;
where createdstimestamp > xxx
However, loads may fail and therefore you miss a 6hr period. I would recommend you load the now variable at the end of your load and save this variable into the qvw. Then your next load can read when the last load completed and load anything after that - even if load(s) fail and more than 6hrs need loading.
Does that answer your question?
Let me know how you get on.
Regards
Steve