1 Reply Latest reply: Jun 29, 2011 3:55 AM by Kaushik Solanki RSS

    holidays

    marco masin

      Hello everybody, I'm marco and i'm from Italy.

      I have a big problem.

      Someone knows a function that returns me the number of non-working days (Sat, Sun) between two dates?

      thank you

        • Re: holidays
          Kaushik Solanki

          HI,

           

             Have a look at this example. You will find this in help of qlikview.

           

           

          networkdays ( start:date, end_date {, holiday} )

          Returns the number of working days (Monday-Friday) between and including start_date and end_date taking into account any optionally listed holidays. All parameters should be valid dates or timestamps.

          Examples:

          networkdays ('2007-02-19', '2007-03-01') returns 9 

          networkdays ('2006-12-18', '2006-12-31', '2006-12-25', '2006-12-26') returns 8 

           

           

          Using this you will get the no. of working days..

           

          To get non working days you can do this ( count the total days - working days.)

           

          Regards,

          Kaushik Solanki