topic Re: Section Access: Row-Level-Reduction on multiple fields in App Development

Section Access: Row-Level-Reduction on multiple fields

SauGuad — Tue, 23 Sep 2025 16:09:52 GMT

Hi,

I am trying to implement section access with row-level reduction based on multiple fields.

We have to maintain 600+ users. We have a team assignment list in SharePoint (name, email, user-id, employee-id, role, team etc.)

The main fact table is call data.

The data reduction should be based on two fields: call_queue and team. For example:

User1: Role = Manager from Team 1 → can see data Team 1–Team 10 and Queue 1–Queue 11
User2: Role = Team Coordinator from Team 2 → can see Team 2 only and Queue 1–Queue 11

I want to know if it is possible to dynamically create data reduction based on the SharePoint list.
At the moment each row in the SharePoint list corresponds to one employee and one team (no call queue).

Depending on the user’s role, they may have access to several teams and queues.

Also, the call_queue field is part of the Call fact table and is not in the team assignment SharePoint list.

Is there any good example using sharepoint list for dynamic row-level-security on multiple fields?

Re: Section Access: Row-Level-Reduction on multiple fields

marksouzacosta — Tue, 30 Sep 2025 17:55:21 GMT

Hi @SauGuad

Yes, it is possible. There are two major things to keep in mind:

1 - Keep in mind Section Access reduces rows by a single column only, that means, if you need to reduce by multiple columns, you'll have to combine these columns into one.

A common practice is to create a BridgeTable to link the Fact table and Section Access table. You'll have to combine all possible values and associate those to the Fact and User tables. This great article will probably answer all your questions: Basics for complex authorization - Qlik Community - 1465872

Regards,

Mark Costa