Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

More Than 1 Section Access Field

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.

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

More Than 1 Section Access Field

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

8 Replies
MVP & Luminary
MVP & Luminary

More Than 1 Section Access Field

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

Not applicable

More Than 1 Section Access Field

yes, u have to link to your real data

mov
Esteemed Contributor III

More Than 1 Section Access Field

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

Not applicable

More Than 1 Section Access Field

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
New Contributor III

Re: More Than 1 Section Access Field

hi,

I am looking for a similar requirement.

Where you able to solve this.?

thanks,

Venu

Not applicable

More Than 1 Section Access Field

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

Not applicable

Re: More Than 1 Section Access Field

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.

xufei123
Valued Contributor

Re: More Than 1 Section Access Field

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