topic Re: Daily and Hourly reload exemption in QlikView

Daily and Hourly reload exemption

Mon, 23 Sep 2013 16:03:59 GMT

Is it possible to skip reload on Saturdays and Sundays for daily reload and late night hours for hourly reload

gopalopsharma — Mon, 23 Sep 2013 17:32:18 GMT

Hello Amir,

Yes, it is.

1. If you are using Qlikview management console (QV11) then

Go to Task created for the qv file
Go to triggers tab
create new, select "on a schedule" from the drop down and you will find relevant info
To create Daily reload except for Weekend, go to Weekly reload option and select the Week days
To create Hourly reload, check the "Run only between" option and set the time there

2. If doing it on Application (QV 11)

Hope this serves the purpose.

Wed, 25 Sep 2013 16:36:36 GMT

I can't find Trigger tab on Qlikview Management Console. Can you please send me snap shot

Clever_Anjos — Wed, 25 Sep 2013 17:07:27 GMT

Gopal, this works only into Publisher

Clever_Anjos — Wed, 25 Sep 2013 17:09:07 GMT

I would include

if match(WeekDay(Today()),'dom', 'sat') then

exit Script

ENDIF

at beginning of script