hierarchy problem

[#1]

My Task is one table  two fields hierarchy processs....

Country                 State      District

INDIA                    AP        CTR

USA                       UP        NLR

UK                          MP       KDP

AUSTRALIA            KA       EAST

1.you select INDIA

2.show AP UP MP KA

3.again select AP THEN SHOW  .......... AP

                                                             UP

                                                             MP

                                                            KA

                                                            CTR

                                                             NLR

                                                             KDP

                                                              EAST

Comes to this way in hierarchy in qlikview processs please help mee any body......

[Peter_Cammaert]

Your last technique that displays just possible values can also (and IMHO more easily) be accomplished by checking "Hide Excluded" in ListBox Properties->General.

[HirisH_V7]

Hi ,

Check this,

Data2:
LOAD * INLINE [
    Setname, Subsetname
    A, 1
    A, 2
    A, 3
    A, 4
    B, 5
    B, 6
    B, 7
    C, 8
    C, 9
];


Left join


Data3:
LOAD * INLINE [
    Child Values, Subsetname
    1.1, 1
    1.2, 1
    1.3, 1
    1.4, 1
    2.1, 2
    2.2, 2
    2.3, 2
    2.4, 2
    3.1, 3
    3.2, 3
    3.3, 3
    4.1, 4
    4.2, 4
    5.1, 5
    5.2, 5
    6.1, 6
    6.2, 6
    7.1, 7
    7.2, 7
    8.1,8
    8.2,8
    9.1,9
    9.2,9
];

By using this above data model output will be like this,

Hope this is the output you desired,

PFA,

Thanks,

-HirisH

[MarcoWedel]

‌HI,

this will leave grey space for excluded values.

regards

Marco

[Peter_Cammaert]

You're right, I hadn't thought of the layout aspect.