Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Knowing that makes perfect sense to join both in the household table.