0 Replies Latest reply: Feb 22, 2013 7:53 AM by lolloldd RSS

    Row value to column name

      I'm new to Qlikview and breaking my head over this problem. I think there's some way to solve it with variables, but I don't know how.

       

      I am trying to rename the General Ledger Segments with the Segment Names. I have 10 segments en 20 levels per segment.

       

      Query for Table 1:

       

      Qualify 
           [Level 1 Code], 
           [Level 1 Description]
      ;
      
      SEGMENT1:
      LOAD 
           [Level 1 Code], 
           [Level 2 Code],
           [Level 3 Code], 
      FROM
      [..\QVD\GL_Hierarchy.qvd]
      (qvd)
      where [Segment Number]=1
      and [Level 1 Code]='T'
      

       

      Query For Table 2:

       

      LOAD 
           COLUMN_NAME as SEGMENT_NUM,  
           SEGMENT_NAME as SEGMENT_NAME
      FROM
      [..\QVD\GL_Segment_Names.qvd]
      

       

      Query For Table 3:

      LOAD
           SEGMENT1, 
           SEGMENT2, 
           SEGMENT3, 
           SEGMENT4, 
           SEGMENT5, 
           SEGMENT6, 
      FROM
      [..\QVD\GL_Code_Combinations.qvd]
      (qvd);
      

       

      Table 1:

       

      SEGMENT1.Level1 Code
      SEGMENT1.Level2 Code
      SEGMENT1.Level3 Code






       

      Table 2:

       

      SEGMENT_NUMSEGMENT_NAME
      SEGMENT1COMPANY
      SEGMENT2ACCOUNT
      SEGMENT3DEPARTMENT
      SEGMENT4PRODUCT

       

      Table 3:

       

      SEGMENT1SEGMENT2SEGMENT3
      0120003000
      0221504000

       

       

      This is how I'd like the field names to be renamed to, but how?:

      Table 1

      COMPANY.Level1 Code
      COMPANY.Level2 Code
      COMPANY.Level3 Code






       

      Table 3

      COMPANYACCOUNTDEPARTMENT
      0120003000
      0221504000