Help with Section Access

[qlikuser222]

Hi All,

I need help with section acesss.

In the below table has the sample data where i want to apply Section access User level, but with some condtions.

Dep, ID, user
123 1 AAA
123, 2, BBB
123, 3, CCC
456, 4, DDD
456, 5, EEE
456, 6, FFF

User BBB and CCC reports to AAA - So AAA should see data for himself and also for BBB and CCC only.
Where BBB and CCC should see only their data

Same way, User EEE and FFF reports to DDD- So DDD should see data for himself and also for EEE and FFF only.
Where EEE and FFF should see only their data.

Please help me.

Thanks in Advance

[Quy_Nguyen]

Hi, 

In this case, you need to create a bridge table for their relationship instead of associating your section access directly with Fact. For example: 

[andykrst]

so what u need here is 2 level security,

1st id for "Dept" and other one is let say "Area"

u need construct your section access data like this , dont forget to add dummy that contain all dept& area

and let it reduce data in your main transaction table like...

let say u log in with AAA, the result is...

and when FFF login,

hope you understand