Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

er_mohit
Honored Contributor II

Dynamic Hierarchy Structure

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

                      D

                      E

            F        G

                      H

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Re: Dynamic Hierarchy Structure

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

3 Replies
er_mohit
Honored Contributor II

Re: Dynamic Hierarchy Structure

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

Partner
Partner

Re: Re: Dynamic Hierarchy Structure

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

MVP
MVP

Re: Dynamic Hierarchy Structure

HIERARCHY(NodeID, ParentID, Node)

LOAD

  Flag as NodeID,

  Flag-1 as ParentID,

  Name as Node;

LOAD * INLINE [

    Name, Flag

    A, 1

    B, 2

    C, 3

    D, 3

    E, 3

    F, 2

    G, 3

    H, 3

];

PFA