topic Re: Section Access with * in QlikView

Section Access with *

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I'm trying to use section access but I don't succeed. I have a simple doc where I use an inline table adding ACCES, NTNAME and DEPARTMENT fields. It is supposed to login automatically recognizing the domain and username and do a reduction by DEPARTMENT.

The thing is that it works when I filter for a specific department, but it doesn't when I try to use the *. It is supposed that using the * and adding other values on the same column (DEPARTMENT in my case) * should represent all listed values. But when I use it it doesn't allow me to open the doc.

I am really stucked on it and I can't find why it is not working as other examples I've found, this one for exampleQlikView Section Access Examples

That's the script I use. Many thanks in advance.

DEP:

load* Inline

[Name, DEPARTMENT

A,ABC

B,XYZ

C,BNH

D,JHK

E,LKJ

F,OLP

];

section_access:

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

];

STAR is *;

SECTION ACCESS;

LOAD

ACCESS,

NTNAME,

DEPARTMENT

RESIDENT section_access;

SECTION APPLICATION;

STAR is;

Re: Section Access with *

Gysbert_Wassenaar — Thu, 16 Jul 2015 16:40:25 GMT

* should represent all listed values

That's right and in the below table only ABC is listed:

sectionaccess_tmp:

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

];

So RUBEN.GRAU will only have access to department ABC

Re: Section Access with *

Qrishna — Thu, 16 Jul 2015 17:00:21 GMT

PSA.

hope that helps.

Use below Ids and pswrds to see their respective data.

ACCESS ,NAME ,PASSWORD ,DEPARTMENT

ADMIN ,RUBEN.GRAU ,RUBEN.GRAU , *

USER ,A ,A , ABC

USER ,B ,B , XYZ

USER ,SOMEONE ,SOMEONE , *

Thanks

Re: Section Access with *

maxgro — Thu, 16 Jul 2015 17:01:17 GMT

in my test it works (*) but not with section access loaded from resident

DEP:

load* Inline

[Name, DEPARTMENT

A,ABC

B,XYZ

C,BNH

D,JHK

E,LKJ

F,OLP

];

//section_access:

//load * inline [

//ACCESS, NTNAME, DEPARTMENT

//USER, domain\RUBEN.GRAU, *

//USER, domain\someone, ABC

//USER, mydomain\myuser, ABC

//];

SECTION ACCESS;

//STAR is *;

load * inline [

ACCESS, NTNAME, DEPARTMENT

USER, domain\RUBEN.GRAU, *

USER, domain\someone, ABC

USER, domain\someone2, XYZ

USER, mydomain\myuser, *

];

//LOAD

// ACCESS,

// NTNAME,

// DEPARTMENT

//RESIDENT section_access;

SECTION APPLICATION;

//STAR is;

Re: Section Access with *

Qrishna — Thu, 16 Jul 2015 17:03:37 GMT

i guess domain\RUBEN.GRAU should be included in the 'Name' field.

if we include it, * works fine.

Please see the script in my qvw attached earlier.

Re: Section Access with *

swuehl — Thu, 16 Jul 2015 17:36:49 GMT

If your user gets access denied, you probably have strict exclusion enabled.

I think what's missing is a

drop table section_access;

at the end of your script. If you don't drop the table, you will get into troubles on opening.