2 Replies Latest reply: Aug 25, 2013 12:37 PM by Jairaj Singh RSS

    Proper format.

    Jairaj Singh

      Hi All,

      I have one sales table in following format:

       

      SALES_DATEDate of sales12/27/201112/27/201112/27/201112/27/201112/27/20113/25/20123/25/20123/25/2012
      SALES_PERSONEmployee's last nameTHOMPSONLEEBROWNLEEGOUNOTTHOMPSONTHOMPSONLEE
      REGIONRegion of salesOntario-SouthOntario-SouthQuebecManitobaQuebecOntario-SouthQuebecOntario-South
      SALESNumber of sales13121312

       

      I want to load data in qlikview in below format

       

      Date of salesEmployee's last nameRegion of salesNumber of sales
      12/27/2011THOMPSONOntario-South1
      12/27/2011LEEOntario-South3
      12/27/2011BROWNQuebec1

       

      How can I achieve this? I tried cross table load but didn't got the proper result. Please help