Hierarchy in qliview

[ManiSK]

childID | Parent ID | Access Type  |   Roles
1                         2          TAI Role Org        eewr
3                        4                     KUU              kjhtrtjl
2                        5            TAI Role Org        wewe
2                         5                 PTS                     kere
2                        5              Mail Group           qw
2                        5             TAI Team                erer
5                                        TAI team                 qw
5                                         Mail grop               wieowej

Hi Guys,

From Above table, first i need to check childID which contains Access Type = TAI Role Org, and need to get parentId of those childID's and if those parentId comes under childid and contains access type = TAI*, we need those childID and Roles column.

Kindly someone help me to get data based on above criteria.

[Brett_Bleess]

Check out the following Design Blog link from Henric Cronstrom, hopefully this may help you out with things:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett