topic Section Access in QlikView

Section Access

saiharsha799 — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Section Access

tresB — Wed, 02 Jan 2019 06:43:26 GMT

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

Re: Section Access

saiharsha799 — Tue, 01 Jan 2019 16:07:29 GMT

Didn't get the result

Re: Section Access

saiharsha799 — Tue, 01 Jan 2019 16:10:21 GMT

Didn't get the result

Re: Section Access

tresB — Wed, 02 Jan 2019 06:48:11 GMT

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

Re: Section Access

Chip_Matejowsky — Thu, 03 Jan 2019 13:22:30 GMT

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.