Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

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.

saiharsha799
Not applicable

Section Access

Hi

Can U plz explain abt the SECTION ACCESS with Example

I have tried my own but i didn't get the result, my code is as follows and in that i din't get only ADMIN while i am entering the User ID like ADMIN, It is showing only empty Filed With *symbol in ProductName.

error.png

 


SECTION Access; Access: LOAD * Inline [ ACCESS,USERID,PWD ADMIN,ADMIN,ADMIN, USER,USER1,USER1 USER,USER2,USER2 USER,USER3,USER3 ]; SECTION Application; LOAD * Inline [ ACCESS,USERID,ProductName ADMIN,ADMIN,* USER,USER1,Cap USER,USER2,Aino Shoes USER,USER3,Duck Shirt ];

 

5 Replies
tresesco
Not applicable

Re: Section Access

For product name column, remove '*' and leave it blank for admin like:

SECTION Access;
LOAD * Inline [
ACCESS,USERID,ProductName
ADMIN,ADMIN,
USER,USER1,Cap
USER,USER2,Aino Shoes
USER,USER3,Duck Shirt
];

 

saiharsha799
Not applicable

Re: Section Access

Didn't get the result

saiharsha799
Not applicable

Re: Section Access

Didn't get the result
Highlighted
tresesco
Not applicable

Re: Section Access

How you are trying seems to be not right. Could you share your sample app?
Support
Support

Re: Section Access

Hey. Have a look at Qlik Support article Section Access 101 which contains links to multiple Section Access resources. 

It seems you are using Product Name as the reduction field. Is this accurate? If so, it should be in all caps.

From the Qlik Design Blog entry "A Primer on Section Access":  All fields in Section Access must be upper case. Hence, the reducing field must be in upper case also in the data. Use the Upper() function and name the fields in upper case.

Sr. Technical Support Engineer with Qlik Support