4 Replies Latest reply: Jul 17, 2013 4:24 AM by michael.kwok RSS

    row records become a column?! Reverse CrossTable structure?

      Hi All

       

      Did any guys experiece like as below

       

      Orginial data from QVD:

       

       

      IDRegionDepartmentCost
      1HKMKT500
      2USAACCT1300
      3TWHR200

       

       

      For some reason, i would like using scripts to change as below:

       

      IDRegionMKTACCTHR
      1HK500

      2USA
      1300
      3TW

      200

       

      Can Qlikview is able to do it?

       

      Many thanks

       

      Mic