3 Replies Latest reply: Jun 22, 2013 9:06 AM by Manish Kachhia RSS

    Cross Table and Number to Date

    Manish Kachhia

      Want to convert this excel data into QlikView format using cross table.

      Need final tables showing

       

      1) Working Date                  Total Pallets Made     Total Pallets Dispatched

      2) Customer Name              Total Pallets Made     Total Pallets Dispatched

       

      Where all Dates showing as a column headers are Working Dates and Rows showing number of pallets.

      + Pallets = New Pallets made on respective Day

      -  Pallets = Pallets dispatched to customer

       

      Thanks....