topic Date function in QlikView

Date function

Mon, 12 Sep 2011 19:54:33 GMT

Is it possible to get the day's between two dates excluding the weekend?

For example:

Startdate Endate

08-09-2011 13-09-2011

Mon, 12 Sep 2011 19:56:23 GMT

Hi,

have u tried with "networkdays" function?

C u,

Stefano

its_anandrjs — Mon, 12 Sep 2011 20:01:51 GMT

Hi,

Use Networkdays( ) function to get the day diference.

Regards

Anand

its_anandrjs — Mon, 12 Sep 2011 20:03:20 GMT

Hi,

Use Networkdays function in your scenario some thing like

=networkdays( '2011-09-08','2011-09-13',"SAT","SUN" )

it returns 4

Regards

Anand

its_anandrjs — Mon, 12 Sep 2011 20:09:14 GMT

Hi,

See the attached sample file it explains networkdays between selected dates

by use

= Networkdays( '2011-09-08','2011-09-13',"SAT","SUN" )

HTH

Regards

Anand

Mon, 12 Sep 2011 20:10:26 GMT

Thank you for the fast respons!

Mon, 12 Sep 2011 22:20:52 GMT

You can also set up an inline table or read from another file declaring public holidays and exclude them too when using the networkdays() function.