1 Reply Latest reply: Mar 1, 2013 2:31 AM by Vishwaranjan Kumar RSS

    Count number of days between two dates

      I am new in Qlikview.I want to calculate number of days between two dates and this date fields are not in a single table.

      for example :-

      'OrderDate'  is in Order Table and 'ShipmentDate' is in Shipment Table.

      please help me out.

       

      Thanks in Advance

        • Re: Count number of days between two dates
          Vishwaranjan Kumar

          NetWorkDays('1/12/12' , '2/11/13')

           

          EXAMPLE--

           

           

          orderdate:

          LOAD * INLINE [

              id, order_date

              1, 1/1/2012

              2, 1/6/2012

              3, 1/8/2012

              4, 1/10/2012

              5, 1/11/2012

          ];

           

          shipmentdate:

          LOAD * INLINE [

              id, shipment_date

              1, 28/1/2012

              2, 25/6/2012

              3, 20/8/2012

              4, 15/10/2012

              5, 22/11/2012

          ];

           

          THEN TAKE A PIVOT TABLE

           

          DIMENSION--  id

                                order_date

                                shipment_date

           

          EXPRESSION--         NetWorkDays(Floor(Date(order_date)),Floor(Date(shipment_date)))