Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn 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

Labels (3)
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