topic Re: Modifying the script dynamically in QlikView

Modifying the script dynamically

Wed, 18 Sep 2013 13:47:12 GMT

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!

Re: Modifying the script dynamically

Wed, 25 Sep 2013 07:53:59 GMT

Nobody knows about it?

Re: Modifying the script dynamically

tresB — Wed, 25 Sep 2013 08:14:32 GMT

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.

Re: Modifying the script dynamically

Wed, 25 Sep 2013 08:31:28 GMT

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