Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kkkumar82
Valued Contributor III

section access with hierarchical data

Hi all,

I have Level3, level2,level1 users in my data and level3 has some level2 under him and level2 has some level1, if a Level3 is accessing I want to implement his , his L2 and L2s L1 data.

for eg if NN logins in I want to implement a section access such that he has to see his(14) ,10 ,11 associated data. I am using hierarchybelongsto but unable to figure out how to map

Authorizationtable -> users table -> bridgetable(hierarchy belongsto) -> fact table

Any help other than hierarchy or hierarchybelongsto??

Thank you

1 Solution

Accepted Solutions
kkkumar82
Valued Contributor III

Re: section access with hierarchical data

followed HIC post Authorization using a Hierarchy

finally got the solution by aliasing one of the columns in the fact table for eg user_id as userid and also aliased

ANCESTORS_KEY of bridge table to userid , so able to get association.

3 Replies
amit_saini
Honored Contributor III

Re: section access with hierarchical data

Hi Kiran,

This may help u:

Authorization using a Hierarchy

Thanks

AS

Re: section access with hierarchical data

Hi Kiran,

Please find the attachment for solution , use 1,2,3,4 and 5 as the userid to log in :

and you can verify the following hierarchy.

USERID,Name,Supervisor_id

1,A,0

2,B,1

3,C,2

4,D,2

5,E,1

];

kkkumar82
Valued Contributor III

Re: section access with hierarchical data

followed HIC post Authorization using a Hierarchy

finally got the solution by aliasing one of the columns in the fact table for eg user_id as userid and also aliased

ANCESTORS_KEY of bridge table to userid , so able to get association.