Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Intern with Hierarchy Question

I am an intern (and new to Qlikview) working with a large organization that has a hierarchy with just over 14,000 nodes. Using code copied from this community, I am able to load and utilize the data if I paste the table into an inline table; however, because there are multiple views of the nodes, and they can change on a monthly basis, I would like load a hierarchy from a view (table) I have stored on a sql server. I can get the pieces to work individually, but I am struggling with how to put it together. 

The following code works, but I would like to replace the inline table with a select all statement. Can this be done?

'T1:

LOAD * INLINE [

  

ID, ParentID, Name

    1, , World

    2, 1, Europe

    3, 1, North America

    4, 1, South America

    5, 1, Africa

    6, 1, Asia

    7, 1, Oceania

    8, 2, UK

    9, 2, France

    10, 2, Italy

    11, 3, USA

    12, 3, Canada

    13, 4, Colombia

    14, 4, Brazil

    15, 5, Nigeria

    16, 5, South Africa

    17, 6, Singapore

    18, 6, Japan

    19, 6, China

    20, 7, Australia

    21, 7, New Zeeland

];

Hierarchy(ID, ParentID, Name,,Name,TreeView) Load

ID,

ParentID,

Name

Resident T1;

drop table T1;'

Thanks!

1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Yes, you can replace the inline load statement with

Select ID, ParentID, Name from (your data source).

View solution in original post

2 Replies
nagaiank
Specialist III
Specialist III

Yes, you can replace the inline load statement with

Select ID, ParentID, Name from (your data source).

View solution in original post

Not applicable

Thank you very much. *bow*