topic Re: Reload one script statement only once in a day in QlikView

Reload one script statement only once in a day

vishsaggi — Tue, 05 Sep 2017 21:22:34 GMT

I have a requirement where i have three script tabs in a qvw document. Like Script1, Script2, Script3 tabs.

I have this qvw scheduled thrice in a day on QMC. I want Script1 tab which has some Load Statements to run only once. Like Reloading only once. For eg: If the schedule trigger on QMC is @9AM, 12PM and @3PM, the Script1 tab should be reloaded only at 9AM it should not be reloaded @ other trigger times.

Any help much appreciated.

Many thnanks,
V.

Re: Reload one script statement only once in a day

rwunderlich — Tue, 05 Sep 2017 21:40:50 GMT

You can wrap the script on tab1 in a conditional that executes only once per day. For example:

IF frac(now(1)) < MakeTime(11) THEN

the script

ENDIF

Re: Reload one script statement only once in a day

vishsaggi — Wed, 06 Sep 2017 02:33:11 GMT

Thanks Rob, will try and get back soon.

Re: Reload one script statement only once in a day

qliksus — Thu, 07 Sep 2017 06:20:28 GMT

Just put the load statement you want to restrict inside a include file and put a condition on top of that

IF time()< 12 then

$(Include=9PMload.txt);

end if

And the remaining load statement after this line

Re: Reload one script statement only once in a day

vishsaggi — Thu, 07 Sep 2017 11:39:21 GMT

Thanks Rob it worked.

Re: Reload one script statement only once in a day

vishsaggi — Thu, 07 Sep 2017 11:39:48 GMT

Thanks Susant,

I will try that too. I am sure it works too.

Re: Reload one script statement only once in a day

vishsaggi — Thu, 07 Sep 2017 11:41:55 GMT

I am trying to mark some responses helpful, but this goes forever when i click on Actions link. Did any one faced the same?

Re: Reload one script statement only once in a day

qliksus — Thu, 07 Sep 2017 12:45:05 GMT

Try after sometime

Re: Reload one script statement only once in a day

vishsaggi — Thu, 07 Sep 2017 13:51:36 GMT

Nope i have been facing this since yesterday, don't know why.

Re: Reload one script statement only once in a day

rwunderlich — Thu, 07 Sep 2017 16:57:04 GMT

Yes, I had the problem in Chrome for several days. It worked in Edge browser. Yesterday it started working in Chrome again. Don't know what the issue is.

-Rob

Re: Reload one script statement only once in a day

vishsaggi — Thu, 07 Sep 2017 19:17:33 GMT

Thanks Rob. Will check later if it fixes.