topic Re: Reload issue in QlikView

Reload issue

rohit214 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,.

I secheduled a reload of an application through publisher(expect Sunday).

Is possible to skip reload on public holiday also through publisher?.

ex. 18/04/2014 is a holiday so can i skip reload today ?

Thanks

Rohit

Re: Reload issue

MK_QSL — Fri, 18 Apr 2014 06:12:33 GMT

What is the condition you have given not to reload on Sunday?

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 06:14:52 GMT

Dear Mahish,

I just unchecked the sunday option.

Thanks

Rohit

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 06:23:30 GMT

any one plz....

Re: Reload issue

Colin-Albert — Fri, 18 Apr 2014 06:34:38 GMT

I don't think you can skip bank holidays directly in publisher. You could add a test at the start of your load script to only load if the date is a working day by using networkdays().

function:networkday

Re: Reload issue

maxgro — Fri, 18 Apr 2014 06:59:10 GMT

it seem s a good solution

if you want to skip some more days you can use an external file (excel, txt) with the days to skip and check it at the beginning as Colin suggested

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 07:15:08 GMT

Dear Collin,

Thanks for ypour answer,

As suggested by using networkday it shows working days (monday- friday) but in my case saturday is also working day so how i'll implement ?

Thanks

Rohit

Re: Reload issue

MK_QSL — Fri, 18 Apr 2014 07:17:53 GMT

You can create a Flag in your script something like for Sunday and Holidays 0 and for rest of the days 1.

Now load the script when Flag = 1 only..

Re: Reload issue

tresB — Fri, 18 Apr 2014 07:22:27 GMT

With your networkdays() check you can simply add an OR If(Weekday(Today())<> 'Sat' )

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 09:10:25 GMT

thanks for your reply tresco and manish, can you please share any example that be very nice.

thanks

rohit

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 09:46:35 GMT

plz guys,,,

Re: Reload issue

rohit214 — Fri, 18 Apr 2014 09:48:42 GMT

thanks i got it