topic Section Access for all the values (*) in QlikView

Section Access for all the values (*)

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

Hi all,

I am trying to implement section access on a field with NTNAME. Here is my script

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

This works perfectly fine on desktop. When I publish this on Server, it says "Failed to open document. Access denied". When tried putting in a value for FIELD beside Admin, I can see the data related to that value or else the access is denied. I cannot manually include all the values for FIELD as I have few hundreds. How can I specify ALL values for Admins. Using * is giving me only A and B access.

Thank you.

Re: Section Access for all the values (*)

krishnacbe — Wed, 13 Jul 2016 20:19:31 GMT

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1,

ADMIN, USER2,

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;

Re: Section Access for all the values (*)

krishnacbe — Wed, 13 Jul 2016 20:20:14 GMT

Hi,

You need to create a dummy table with all the distinct FIELD and join it with your default section access table.

Hope below example will give you details.

Section_Access_Table:

Load

'ADMIN' as ACCESS,

'ADMIN' as NTNAME,

SQL select distinct FIELD from Table_Name;

concatenate

LOAD * INLINE [

ACCESS, NTNAME, FIELD

ADMIN, USER1, *

ADMIN, USER2, *

USER, USER3, A

USER, USER4, B ];

Section Access;

Load * from Section_Access_Table;

Section Application;