topic Find first workdate in QlikView

Find first workdate

Fri, 24 Apr 2009 22:31:28 GMT

What is the easiest way to identify the first workdate (Mon-fri) for each month?

Find first workdate

disqr_rm — Fri, 24 Apr 2009 22:44:05 GMT

Try function firstworkdate. Syntax is: firstworkdate( end_date, no_of_workdays {, holiday} )

Thanks

Find first workdate

Fri, 24 Apr 2009 22:57:32 GMT

But that will slide over to the previous month sometimes and return e.g the last day of the previous month? How do I define no_of_workdays in a good way?

Thanks!

Find first workdate

wizardo — Fri, 24 Apr 2009 23:07:55 GMT

i think :

Today() - MonthStart(Today()) should do the trick

Mansyno

Find first workdate

disqr_rm — Fri, 24 Apr 2009 23:24:15 GMT

I haven't tried this function myself. Will check.

In the meantime you may calculate it yourself in the code:

LOAD Monthname, date(min(Date)) as FirstWorkDate group by Monthname;
LOAD *, monthname(Date) as Monthname
where weekday(Date) < 5;
LOAD today()-recno() as Date autogenerate 365;

Find first workdate

Fri, 24 Apr 2009 23:26:47 GMT

But that will result in a date from a previous month?

firstworkdate('2009-04-10',Today() - MonthStart(Today()))

returns 3/11/2009 for example.

Find first workdate

Fri, 24 Apr 2009 23:31:58 GMT

Yes I will do it in the load script instead. Thank you very much!