topic Re: Last working day in QlikView

Last working day

Fri, 07 Dec 2012 09:54:32 GMT

Hi everyone.

I would like some help trying to create a variable for the last working date. It must also include public holidays which i already have in a spreadsheet.

I am trying to add a button in my application for LWD (Last Working Day) which when pressed the date selection changes to the last working date.

My fields are :

[Event Date]

PublicHols

I know there is a function NETWORKDAYS but i don't know where to start...

Any help would be appreciated.

Thanks

Re: Last working day

Gysbert_Wassenaar — Fri, 07 Dec 2012 09:57:02 GMT

The lastworkdate is probably the function you're looking for. It also excepts holidays are arguments. See the help file for details.

Re: Last working day

Fri, 07 Dec 2012 10:45:27 GMT

Hi thanks,

I dod't understand it though. how do i get the last working date?

the example gives..

lastworkdate ('2007-02-19', 9) which returns '2007-03-01' which is a date in the future...

so if i try

LastWorkDate(Today(),-1) i get null

or am i completely missunderstanding it?

Re: Last working day

swuehl — Fri, 07 Dec 2012 11:01:20 GMT

Even if this sounds non intuitive, I think you should look into FirstWorkDate() instead, like

=FirstWorkDate(today(),1)

add a comma separated list of holiday dates after the second argument.

Re: Last working day

Fri, 07 Dec 2012 11:25:28 GMT

Hi, thansk that worked

how do i use a field name for my holiday dates?

I have loaded them in from an excel file and named the field 'PublicHols' but not sure how to include it

The help file says to use this format...

FirstWorkDate(end_date, no_of_workdays {, holiday} )

so i have tried

=FirstWorkDate('07/12/2012',2{, PublicHol})

but i get an error on the comma after the curly open bracket..

Re: Last working day

swuehl — Fri, 07 Dec 2012 11:29:18 GMT

{, ...} just means it's optional to the function call.

Here is a description on how to create and add your holiday values:

http://community.qlik.com/message/90025