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);
|SEGMENT1.Level1 Code||SEGMENT1.Level2 Code||SEGMENT1.Level3 Code|
This is how I'd like the field names to be renamed to, but how?:
|COMPANY.Level1 Code||COMPANY.Level2 Code||COMPANY.Level3 Code|