Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

Reload issue

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

11 Replies
MK_QSL
MVP
MVP

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

rohit214
Creator III
Creator III
Author

Dear Mahish,

I just unchecked the sunday option.

Thanks

Rohit

rohit214
Creator III
Creator III
Author

any one plz....

Colin-Albert

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

maxgro
MVP
MVP

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

rohit214
Creator III
Creator III
Author

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

MK_QSL
MVP
MVP

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..

tresesco
MVP
MVP

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

rohit214
Creator III
Creator III
Author

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

thanks

rohit