Row value to column name

Fri, 22 Feb 2013 10:14:19 GMT

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_NUM	SEGMENT_NAME
SEGMENT1	COMPANY
SEGMENT2	ACCOUNT
SEGMENT3	DEPARTMENT
SEGMENT4	PRODUCT

Table 3:

SEGMENT1	SEGMENT2	SEGMENT3
01	2000	3000
02	2150	4000

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

COMPANY	ACCOUNT	DEPARTMENT
01	2000	3000
02	2150	4000

topic Row value to column name in QlikView

Row value to column name