Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with Section Access

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

2 Replies
Quy_Nguyen
Specialist
Specialist

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: 

Quy_Nguyen_0-1618209761346.png

 

andykrst
Contributor III
Contributor III

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

andykrst_1-1618475706693.png

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

andykrst_2-1618475727330.png

 

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

andykrst_3-1618475745295.png

and when FFF login,

andykrst_4-1618475768506.png

hope you understand