topic Re: how to make hirarchy using some different field in QlikView

how to make hirarchy using some different field

marjan_it — Sat, 11 Mar 2017 07:38:03 GMT

Hi All

I have some field that are organization chart like this:

RECEIVER_POST_L1_CHART_ID	RECEIVER_POST_L2_CHART_ID	RECEIVER_POST_L3_CHART_ID	RECEIVER_POST_L3_CHART_NAME
1	2	4	8
1	2	4	9
1	2	5	10
1	2	5	11
1	3	6	12
1	3	6	13
1	3	7	14

I want to show this data in listbox in as a treeview. how can I do this?!

Re: how to make hirarchy using some different field

swuehl — Sat, 11 Mar 2017 08:28:52 GMT

Maybe just create a new field with a concatenated string made of the four other fields, something like:

LOAD

Level1,

Level2,

Level3,

Level4,

Level1 &'/'& Level2 &'/'& Level3 &'/'& Level4 as HierarchyString

FROM ....

Then in the list box, enable option 'Show as treeview' in list box properties, general tab.

Re: how to make hirarchy using some different field

marjan_it — Sun, 12 Mar 2017 05:59:44 GMT

IT shows hirarchy level but its not relation with other data and does not show the selected Item.

look at the attached file!!!

Re: how to make hirarchy using some different field

swuehl — Sun, 12 Mar 2017 11:55:24 GMT

It does show the relation to the selected value as possible value (white background in list box), don't you see it in your version?

You can also create the hierarchy string as expression in the list box, just like a calculated dimension:

=RECEIVER_POST_L1_CHART_ID &'/'& RECEIVER_POST_L2_CHART_ID &'/'& RECEIVER_POST_L3_CHART_ID &'/'& RECEIVER_POST_L4_CHART_ID

Now, when you select the hierarchy item, all the underlying level values will be selected as well.

Same, when you select values in all levels, the hierarchy value in the list box will be selected (but not if you select e.g. only in the lowest level).

Re: how to make hirarchy using some different field

marjan_it — Tue, 14 Mar 2017 06:06:36 GMT

Thank you for your complete answer.

another thing! if one of leaf was null if its parent selected it shows a white line after its parent.

if I want the parent be white what should i do.

in another mean I want to omit null leaf ?!!!!!

Re: how to make hirarchy using some different field

swuehl — Tue, 14 Mar 2017 08:52:45 GMT

Guess you need to only append the part if it's not null:

=RECEIVER_POST_L1_CHART_ID &'/'& RECEIVER_POST_L2_CHART_ID &'/'& RECEIVER_POST_L3_CHART_ID & If(Len(RECEIVER_POST_L4_CHART_ID), '/'& RECEIVER_POST_L4_CHART_ID,'')