topic Re: firstworkdate() in QlikView

firstworkdate()

Anonymous — Fri, 20 Feb 2015 15:47:57 GMT

FirstWorkDate(Today(), 1, ’04-Jul-2014′)

Note: Today is 6^th July 2014.

This function returns 03-Jul-2014 because 06-Jul-2014 is Sunday, 05-Jul-2014 is Saturday and 04-Jul-2014 is a holiday

if it is 2015 on the same date how can i go back to application and edit 2015 instead of 2014??

is there any solution to write with out years??

Re: firstworkdate()

Anonymous — Fri, 20 Feb 2015 16:05:52 GMT

What are you trying to solve with this? Do you only want to use this specific date? Is there a range of years you'd like to use? There are a few ways to accomplish what you're looking to do, but more details are needed.

Re: firstworkdate()

Anonymous — Fri, 20 Feb 2015 17:16:12 GMT

actually i want to display previous day data like Monday to Friday avoid Saturday and Sunday

->for above requirement i already wrote a expression by using Firstworkdate()

but now i want to avoid holidays also !!!

Re: firstworkdate()

Fri, 20 Feb 2015 17:31:27 GMT

Refer this post:Calculating Holidays in script

Hope this helps.

Re: firstworkdate()

Anonymous — Fri, 20 Feb 2015 17:45:02 GMT

You can also go out and scrape government websites too to get a list, depending on your location as well, to get a list of holidays. The put them into a variable and use the variable in your calculation.

firstworkdate(Today(), 1, $(vHolidays))

I've attached an example for getting the data.