Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
Not applicable

Section Access using multiple fields

I would like to set up section access on an app using different fields for different users. I have REGION field and an OFFICE field. Some users would be restricted to an OFFICE and others to a REGION. NB. there is a 1-M link beween regions and offices.

I have set up section access using just one field with the following:

Section Access;

LOAD * INLINE [

ACCESS,USERID,OFFICE

ADMIN,EMEA\test,

USER,EMEA\test_restricted,Cambridge

];

Section Application;

I thought the following might work but no luck. I have read on the forum a way of concatenating the fields used for section access but that seems like  a more complicated way of introduced quite sophisticated access restrictions. I don't need the extra complications and was hoping for an easier way?

Section Access;

LOAD * INLINE [

ACCESS,USERID,OFFICE, REGION

ADMIN,EMEA\test,,

USER,EMEA\test_restricted1,Cambridge,

USER,EMEA\test_restricted2,,NorthWest

];

Section Application;

1 Reply
felipedl
Valued Contributor III

Re: Section Access using multiple fields

Hi David,

I've made an example for two fields, but you could put more on your app.

The first inline load would give me the section access I require (that could also be loaded from an Excel file for example) and then manipulate the section access with left join to make the full login for all users.

Just the admin is left with visibility for all fields. To enter with the admin login,

User: admin

Pass: admin

Felipe.

Community Browser