Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Display Names of Geo Levels in Hirarchy

Dear All,

I Have problem with hirarchy following is script in my qvw  I want to display employee names along with HQ is linked I made changes in sql script and brig employee names in front of Head Qtrs  and in load I have added employee name but employee names showing me as blank.

DIM_GeoHQMaster:

HIERARCHY(CHILD_ID, PARENT_ID, [HQ], [Parent Name], [HQ], [Path Name], '/')

LOAD Hqid AS [HQ Code],

     Hqname AS [HQ],

     GeoLevelName AS [Level Name],

     CHILD_ID,

     PARENT_ID,

     [EmpName],   <-------------------------------------[ Added New Column in Hirerchy]

     [Email]

FROM

[..\Qvds\DIM_GeoHQMaster.qvd]

(qvd);

How to link  employee - SGID+HQID  is link between both tables.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
0 Replies