topic Re: Dynamic Hierarchy Structure in QlikView

Dynamic Hierarchy Structure

er_mohit — Fri, 11 Jul 2014 11:40:32 GMT

Hi Friends

M stuck off facing this problem. here's an example

like i have a table

LOAD * INLINE [

Name, Flag

A, 1

B, 2

C, 3

D, 3

E, 3

F, 2

G, 3

H, 3

];

I want output as alike hierarchy wise on basis of flag

so, in pivot i want this

Level1 Level2 Level3

A B C

F G

here, when i expand A then it gives all data of Level2 and Level3

but when i expand Level2 F value it gives G and H in Level3

Any help will be appreciated.

Re: Dynamic Hierarchy Structure

er_mohit — Fri, 11 Jul 2014 12:33:33 GMT

Please help me here i want

in three separate field

Level1 gives value A

level2 gives B and F

Level 3 gives C,D,E,F,G,H

here in level2 if i select B then in Level3 gives C,D,E

when i select F value in Level2 then it gives F,G,H

or if can't possible please suggest me how to make Correlated flag in data source so, that it can give like this output

Re: Re: Dynamic Hierarchy Structure

nilo_pontes — Fri, 11 Jul 2014 12:40:11 GMT

Hi Mohit,

Please see if the attached file helps you.

You might want to take a look at this article as well: Hierarchies

Best Regards,

Nilo

Re: Dynamic Hierarchy Structure

tresB — Fri, 11 Jul 2014 12:47:55 GMT

HIERARCHY(NodeID, ParentID, Node)

LOAD

Flag as NodeID,

Flag-1 as ParentID,

Name as Node;