Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Yes, you can have multiple fields in Section Access, but you need to link them separately to the corresponding fields in your Section Application
Yes, you can have multiple fields in Section Access, but you need to link them separately to the corresponding fields in your Section Application
yes, u have to link to your real data
Make sure to change 'Canada' to 'CANADA' - field values must be all capital. Same on the application table side.
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?
hi,
I am looking for a similar requirement.
Where you able to solve this.?
thanks,
Venu
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
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.
Same issue. Just like Jonas has described. How to set section access to FIELD1 OR FIELD2??