More Than 1 Section Access Field

[#1]

Can you use more than one field in section access reduction? I want to limit someone to only be able to see Canada in America.

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, REGION, COUNTRY
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, AFRICA, *
USER, USER2, U2, AMERICA, Canada
USER, USER3, U3, ASIA, *
USER, USER3, U3, ASIA, *
];

thanks.

[Oleg_Troyansky · Accepted solution]

Yes, you can have multiple fields in Section Access, but you need to link them separately to the corresponding fields in your Section Application

[#3]

yes, u have to link to your real data

[Anonymous]

Make sure to change 'Canada' to 'CANADA' - field values must be all capital. Same on the application table side.

[#5]

Thanks oleg. Quick question though. Am i right in assuming that the line:

USER, USER1, U1, AFRICA, *

will give USER1 access to all countries in AFRICA. Not all countries in all regions, just africa?

[qlik_venu]

hi,

I am looking for a similar requirement.

Where you able to solve this.?

thanks,

Venu

[#7]

Hi,

I have a similar requirement.

I have 2 fiels in section access and these two fields have to be linked like OR not AND.

section access:

USER, FIELD1, FIELD2

JONAS, 2511, 1100

JONAS, 2513, 1110

JONAS, 2515, 1120

section application:

FIELD1, FIELD2

2511, 1100

2511, 1110

2513, 1110

3000, 1100

2511, 4000

In this example user JONAS should see all records from APPLICATION, because he has access to FIELD1 OR FIELD2 of all records.

In actual case my qlikview "deletes" the records 3000, 1100 and 2511, 4000 on open. It seems to "klick" both fields from section access (FIELD1 AND FIELD2) but I need an FIELD1 OR FIELD2.

Can anyone help me?

Thanks,

Jonas Gros

[#8]

Hi Oleg,

Can you provide an example on how to link seperately.  I am having the same issue with multiple field data reduction via section access.

Appreciate your help.

[NZFei]

Same issue. Just like Jonas has described. How to set section access to FIELD1 OR FIELD2??