Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
shane_spencer
Specialist
Specialist

Similar script function to lastworkdate

I'm using lastworkdate in my script to work out X working days before my start date. However I've been told for some countries in my data the working week is Mon-Sat (not Mon-Fri). How can I do this? I've got a calendar and can easily get a list of all Sundays and Holidays to put in a variable take away from my start date, if only there's some way to take X days from my start excluding the dates in the list. 

Labels (1)
0 Replies