Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avinashkk696
Contributor III
Contributor III

Section Access Is not restriction the field values

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. 

1 Solution

Accepted Solutions
krishnacbe
Partner
Partner

Hi

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

View solution in original post

3 Replies
krishnacbe
Partner
Partner

Hi

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

View solution in original post

MK9885
Master II
Master II

Check this box in Document Properties>Opening

Capture.PNG

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;

ger_alegria
Partner
Partner


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