Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

ali_hijazi
Honored Contributor

Help in Qlik Sense Section Access

Hello

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

schema.png

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

3 Replies
carlos_reyes_qv
Valued Contributor

Re: Help in Qlik Sense Section Access

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
Honored Contributor

Re: Help in Qlik Sense Section Access

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_qv
Valued Contributor

Re: Help in Qlik Sense Section Access

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

Community Browser