topic Re: Section Access Is not restriction the field values in QlikView

Section Access Is not restriction the field values

avinashkk696 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Experts,

I have the below section access code. It seems like it is not working as expected.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, NAME

ADMIN, ADMIN, 123, KUMAR

USER, USER1, 1234, KRIS

ADMIN, VISU, 111, MONA

];

Section Application;

table1:

LOAD

LOAD EmpID,

upper(Name) as NAME,

State,

Dept,

Salary,

LastModified

FROM

(ooxml, embedded labels, table is Sheet1);

I want to restrict the field values in Name Field according to the script above.

Re: Section Access Is not restriction the field values

krishnacbe — Thu, 23 Feb 2017 19:24:02 GMT

You need to enable the checkbox "Initial Data Reduction Based on Section Access" and "Strict Exclusion" in Document Properties -> Opening Tab

Re: Section Access Is not restriction the field values

MK9885 — Thu, 23 Feb 2017 20:51:21 GMT

Check this box in Document Properties>Opening

For me if I login as ADMIN, I see my name as KUMAR and it is working fine.

If you want ADMIN to view all names (see below script) then you should add all the NAMES to Section Access Inline or define it somewhere in XL.

LOAD EmpID,

     Upper(Name) as NAME,

     State,

     Dept,

     Salary,

     LastModified

FROM..............

Star is *;

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NAME

    ADMIN, , 123, *

    USER, USER1, 1234, KRIS

    ADMIN, VISU, 111, MONA

    USER, , 1, Ramesh

    USER, , 2, Steve

    USER, , 3, John

    USER, , 4, Sofie

    USER, , 5, Henry

    USER, , 6, Mark

    USER, , 7, Andrew

    USER, , 8, Khedar

    USER, , 9, Steffy

    USER, , 10, Morog

    USER, , 11, Rex

    USER, , 12, Malathi

    USER, , 13, Rajeswari

    USER, , 14, Vijay

    USER, , 15, Raj

    USER, , 16, Keshav

    USER, , 17, Balaji

    USER, , 18, KUMAR

];

Section Application;

Re: Section Access Is not restriction the field values

ger_alegria — Thu, 23 Feb 2017 21:57:54 GMT

You have to enable the checkbox "Initial Data Reduction Based on Section Access" and enable the checkbox "Strict Exclusion".

Go to Document Properties and Opening Tab.

With this your section application will works