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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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