Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rohit214
Contributor 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
MVP
MVP

Re: Reload issue

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

rohit214
Contributor III

Re: Reload issue

Dear Mahish,

I just unchecked the sunday option.

Thanks

Rohit

rohit214
Contributor III

Re: Reload issue

any one plz....

Re: Reload issue

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

MVP
MVP

Re: Reload issue

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
Contributor III

Re: Reload issue

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

MVP
MVP

Re: Reload issue

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

MVP
MVP

Re: Reload issue

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

rohit214
Contributor III

Re: Reload issue

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

thanks

rohit

Community Browser