topic Re: Help with Section Access in App Development

Help with Section Access

qlikuser222 — Sat, 16 Nov 2024 00:16:26 GMT

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

Re: Help with Section Access

Quy_Nguyen — Mon, 12 Apr 2021 06:44:21 GMT

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:

Re: Help with Section Access

andykrst — Thu, 15 Apr 2021 08:36:23 GMT

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