how to give section access by two fields ?

[gauravgg]

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

[Lauri]

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.