Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 error.png](https://community.qlik.com/t5/image/serverpage/image-id/2807i4BF8C31E15B88A0B/image-size/large?v=v2&px=999)
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 ];
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 ];
Didn't get the result
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.