Help in Qlik Sense Section Access

[ali_hijazi]

Hello

I'm working on a Qlik Sense dashboard and I got the following schema:

there are two tables Community and Projects (highlighted) in red

Users who will access the dashboard need to have permissions on communities and projects i.e. some users may see community C1 and related projects P1 and P2

Other users may see all communities and thus all projects

Other users may see communities C1, and all related projects and community C2 and project P3

Please help in the section access syntax here as reduction is to be made on 2 fields in separate tables

[Carlos_Reyes]

IMHO, you'll need to add the project and community keys to the household (Edit. Member) table (using joins or applymaps), which is the one that unifies both entities... so you have a table with all the possible or valid household, project and community combinations.

Once you have that, you can rename the filelds so you don't get synthetic keys or create a new field that combines the project and community fields into one by concatenating them.

Then its up to you if you want to use the concatenated field or both renamed fields as the Section Access filters.

[ali_hijazi]

no I think I should add community to project_household_assoc table

not the member because households reside in communities and households are assigned to projects

so the household key would be field containing both the household_id and community_id

[Carlos_Reyes]

Knowing that makes perfect sense to join both in the household table.