Section Access

[saiharsha799]

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.

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
];

[tresesco]

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]

Didn't get the result

[saiharsha799]

Didn't get the result

[tresesco]

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

[Chip_Matejowsky]

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.