topic Re: More Than 1 Section Access Field in QlikView

More Than 1 Section Access Field

Wed, 09 Mar 2011 23:36:55 GMT

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.

More Than 1 Section Access Field

Oleg_Troyansky — Wed, 09 Mar 2011 23:50:43 GMT

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

More Than 1 Section Access Field

Thu, 10 Mar 2011 02:32:19 GMT

yes, u have to link to your real data

More Than 1 Section Access Field

Anonymous — Thu, 10 Mar 2011 02:49:03 GMT

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

More Than 1 Section Access Field

Thu, 10 Mar 2011 15:52:56 GMT

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?

Re: More Than 1 Section Access Field

qlik_venu — Tue, 25 Oct 2011 03:59:17 GMT

hi,

I am looking for a similar requirement.

Where you able to solve this.?

thanks,

Venu

More Than 1 Section Access Field

Wed, 18 Jan 2012 10:24:33 GMT

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

Re: More Than 1 Section Access Field

Mon, 23 Jul 2012 04:52:08 GMT

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.

Re: More Than 1 Section Access Field

NZFei — Wed, 26 Sep 2012 04:25:50 GMT

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