Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
saiharsha799
New Contributor II

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
Highlighted
MVP
MVP

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

Re: Section Access

Didn't get the result

saiharsha799
New Contributor II

Re: Section Access

Didn't get the result
MVP
MVP

Re: Section Access

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

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
Community Browser