Qlik Community

App Development

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

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

how to give section access by two fields ?

Hi all

I have an qliksense application, i have to give section access to the users

I want to give some users access by category and some users by sector.


for eg 

i want to give 40 users access by category , and 60 users access by sector


How should i create section access file for this application ?

Can anyone help me in this ?

Thanks in advance

1 Reply
Lauri
Specialist
Specialist

Someone else may have a better idea, but here's what I might do:

Section Access:

users:

Load * Inline [

USER, ACCESS, CATEGORY, SECTOR, OMIT

JOE, USER, 1, 1,

MATT, USER 1, 2,

SUE, USER, 2, 2,

];

Section Application:

Categories:

Load CATEGORY, [all other fields]

From ...;

Sectors:

Load SECTOR, [all other fields]

From ...;

Notes about this:

  • I have only put one field into a section access table; hopefully putting in two (CATEGORY and SECTOR) works. If not, then create a new field that is the key; it could be CATEGORY & '_' & SECTOR As csKey, and load it into the users table as well as Categories and Sectors tables.
  • Be sure to capitalize all section access fields and values, if string.