Discussion Board for collaboration on QlikView Publisher.
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 ?
What is the condition you have given not to reload on Sunday?
I just unchecked the sunday option.
any one plz....
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().
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
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 ?
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..
With your networkdays() check you can simply add an OR If(Weekday(Today())<> 'Sat' )
thanks for your reply tresco and manish, can you please share any example that be very nice.