Discussion board where members can learn more about Qlik Sense App Development and Usage.
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, user123 1 AAA123, 2, BBB123, 3, CCC456, 4, DDD456, 5, EEE456, 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
In this case, you need to create a bridge table for their relationship instead of associating your section access directly with Fact. For example:
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