Intern with Hierarchy Question

Wed, 11 Jul 2012 13:54:41 GMT

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!

Re: Intern with Hierarchy Question

nagaiank — Wed, 11 Jul 2012 14:02:07 GMT

Yes, you can replace the inline load statement with

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

Re: Intern with Hierarchy Question

Wed, 11 Jul 2012 14:16:41 GMT

Thank you very much. *bow*

topic Re: Intern with Hierarchy Question in QlikView

Intern with Hierarchy Question

Re: Intern with Hierarchy Question

Re: Intern with Hierarchy Question