1 Reply Latest reply: Jul 30, 2011 9:28 AM by Stefan Wühl RSS

    Monthwise Data Needed

      Please check enclosed table showing Customer Name, Customer ID and Date wise data for number of pallets made/dispatched at/from our warehouse. Positive numbers showing pallet made at warehouse and negative numbers showing pallets dispatched to customer from our warehouse.

       

      I want below table in Qlikview.. Kindly provide me code for the same. Also, while loading I can see that date is automatically formated in numbers. How can I get Date instead of numbers while selecting fields in qlikview.

       

      DescriptionTOTALJanuaryFebruary
      Total Pallets Made947123
      Total Pallets Dispatched883441