topic Re: Re: Country Hierarchy as Treeview in QlikView

Country Hierarchy as Treeview

Wed, 20 Aug 2014 08:24:48 GMT

Hi All,

I am trying to build a country hierarchy. Please help.

This is my data table where i have the country field.

SQL Select DEALER, COUNTRY,WAVE,...,....

From TABLE1 WHERE ENABLED='YES';

i created a below table and tried for country hierarchy

NODE_ID	NAME	PARENT_ID
1	ALL MARKET	NULL
2	GCC MARKET	1
3	Abu Dhabi	2
4	Bahrain	2
5	Dubai-SZR	2
6	Garhoud	2
7	Iraq	2
8	Jeddah	2
9	Jordan	2
10	Khobar	2
11	Kuwait - LR	2
12	Kuwait	2
13	Lebanon-JR	2
14	Lebanon-LR	2
15	Marrakech	1
16	Morocco	1
17	Oman	2
18	Qatar	2
19	Rabat	1
20	Casablanca	1
21	Riyadh	2
22	Sharjah	2
23	Tunisia	1
24	Algeria	1
25	Azerbaijan	1
26	Egypt	1

Thanks.

Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 08:28:35 GMT

Try like:

Hierarchy(NODE_ID, PARENT_ID, NAME)

LOAD

NODE_ID,

PARENT_ID,

NAME

From <>;

Then in the front end use treeview in list box with '/' separator.

Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 08:32:23 GMT

Hi,

I tried as below

COUNTRY_HIERARCHY:

Hierarchy (NODE_ID, PARENT_ID, NAME)

Select NODE_ID,

PARENT_ID,

NAME

From XX_JLR_MS_COUNTRY ;

But how to link this with Country in below table

Select DEALER, COUNTRY,WAVE,...,....

From TABLE1 WHERE ENABLED='YES';

Thanks

Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 08:39:28 GMT

Well, try joing them like:

Tree:

Hierarchy(NODE_ID, PARENT_ID, COUNTRY)

LOAD

NODE_ID,

PARENT_ID,

NAME as COUNTRY ; // Preceding load

Select COUNTRY From <>;

Join

Load * From <YourTreeTable>;

Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 10:30:13 GMT

Hi,

I tried and couldn't make it.

Please find the attached QV file.

Could you please help me.

Thanks

Re: Re: Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 10:35:00 GMT

Use pivot like in attached qvw. For better understanding read: Hierarchies

Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 10:44:02 GMT

Hi,

I need to display like this in a tree view. based this selection values should populate across all tabs.

All Market

GCC

KSA

Thanks.

Re: Re: Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 10:48:05 GMT

just add one more field in the hierachy like:

Hierarchy (NODE_ID, PARENT_ID, COUNTRY, Path)

Now in the front end use this Path listbox and use tree view with separator '/'

Re: Re: Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 11:00:13 GMT

Hi tresesco,

If i select ALL Market from Country list box it is not displaying the result in tables.

Thanks

Re: Re: Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 11:12:16 GMT

Path is empty.

Please help me to fix this issue

Thanks

Re: Re: Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 11:16:21 GMT

My mistake. Try:

Hierarchy (NODE_ID, PARENT_ID, COUNTRY, Parent, COUNTRY, PathName)

Then use PathName. Else re-upload your sample qvw.

Update: Corrected the field reference

Re: Re: Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 11:21:18 GMT

Hi Tresesco,

Thanks you for your time and support.

PathName is displaying empty.

I am uploading my QV file.

Appreciate you could help me to fix this issue.

Thanks.

Re: Re: Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 11:25:44 GMT

Note my update above.

Re: Re: Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 11:30:48 GMT

Thanks a lot Tresesco,

I have one last question. If i select directly "All Market" or "GCC" is not giving any result.

I have click the - symbol to get the result. It is there is any other way ? so that if i select "All Market" it will display the result.

Thanks

Re: Re: Re: Country Hierarchy as Treeview

tresB — Wed, 20 Aug 2014 11:49:45 GMT

Yes, there is. You have to use HierarchyBelongsTo. Please refer the link I provided above for details.

Re: Re: Re: Re: Country Hierarchy as Treeview

Wed, 20 Aug 2014 12:35:06 GMT

Thank you for your support