topic Re: Section Access in QlikView

Section Access

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

Hi There

Something is not working correctly in my section access.

My qlikview user is peterz.

when reloading with the below section access applied.

my user peterz can only see CODE_2 A12.

According to my script, peterz must have access to all CODE_2

it seems as if all other users can also only see A12

for now it seems like kevin can see only A12 CODE_2s linked to COST_CENTRE 2101.

he needs to see all CODE_2s for COST_CENTRE 2101

Your assistance is appreciated.

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,*, *
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

];

Section Application;

Re: Section Access

rido1421 — Thu, 21 May 2015 06:45:34 GMT

FYI.

I have tried using CAPS

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.

Re: Section Access

PrashantSangle — Thu, 21 May 2015 06:46:56 GMT

Hi,

Kept it blank to give all acesss

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,,
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

];

Section Application;

Regards

Re: Section Access

PrashantSangle — Thu, 21 May 2015 06:49:35 GMT

* represent the value for that which mention in section Access

and to give all access you have kept that field blank.

Regards

Re: Section Access

rido1421 — Thu, 21 May 2015 06:52:35 GMT

Thanks Max Dreamer

I will try it and let you know. just to confirm, when you do a Debug load with section access does it work correctly?

Re: Section Access

PrashantSangle — Thu, 21 May 2015 06:56:58 GMT

Hi,

Depend on data...

Regards

Re: Section Access

Thu, 21 May 2015 07:16:36 GMT

hi,

keep blank at the place of *. they will see all values.

LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2

USER, domainname\kevinw , 2101,

];

Regards

Vimlesh

Re: Section Access

rido1421 — Thu, 21 May 2015 07:27:37 GMT

"Failed to Open Document, You do not have access to this document"

This is the Error received... when tryng to access through the access point

Re: Section Access

rido1421 — Thu, 21 May 2015 07:29:01 GMT

Hi Vimesh

If I remove my User: peterz will it not take away my access to the document completely?

Re: Section Access

Anonymous — Thu, 21 May 2015 07:32:10 GMT

Generally Debug load with section access does not work .

You need to reload the document save it and close it .

Again open the doc .you should be able to login with correct user ID pwd.

Re: Section Access

Anonymous — Thu, 21 May 2015 07:32:52 GMT

are you able to access from desktop ?

Re: Section Access

PrashantSangle — Thu, 21 May 2015 07:33:17 GMT

Hi,

For which user you are getting that error??

Try with Capital Letters

Regards

Re: Section Access

jonathandienst — Thu, 21 May 2015 07:33:51 GMT

Use the script given to you above by max dreamer - dreamer4

Re: Section Access

avinashelite — Thu, 21 May 2015 07:34:14 GMT

Hi Rido,

It depends on the data what you have, and how your defining in the section application.

can you please share the sample app

Re: Section Access

rido1421 — Thu, 21 May 2015 07:35:21 GMT

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,,
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

I am getting it for peterz. after doing the above...

I have tried Capital and lowercase.

Re: Section Access

rido1421 — Thu, 21 May 2015 07:36:46 GMT

I am trying from the desktop through the access point.

Im afraid to close the document on the server after saving as it might block me out of the document on the server.

peterz is my user on the server aswell.

Re: Section Access

rido1421 — Thu, 21 May 2015 07:38:54 GMT

Hi Jonathan

I have used the Script. it has taken access for peterz away completely...

Re: Section Access

avinashelite — Thu, 21 May 2015 07:40:24 GMT

try some things like this

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\Johna , *, A12
USER, domainname\peterz ,*,*
USER, domainname\paulo ,*,*

USER, domainname\kevinw , 2101,*

Re: Section Access

ToniKautto — Thu, 21 May 2015 07:41:21 GMT

A few things to look at with your example;

- All fields in the section access table must be in UPPER case

- You might want to have at least one ADMIN level user

- * represents all values listed in the reduction field, use a non existing value to represent all data values

Section Access;
LOAD * INLINE [
ACCESS, NTNAME, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>

USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>

];

Section Application;

Try using USERID instead of NTNAME during your development work. That way you can impersonate your users in an easy way, by entering the USERID in the login credentials.

Section Access;

LOAD * INLINE [
ACCESS, USERID, COST_CENTRE, CODE_2
USER,DOMAINNAME\JOHNA , <ALL VALUES>, A12
USER, DOMAINNAME\PETERZ ,<ALL VALUES>, <ALL VALUES>
USER, DOMAINNAME\PAULO ,<ALL VALUES>,<ALL VALUES>

USER, DOMAINNAME\KEVINW , 2101,<ALL VALUES>

];

Section Application;

Re: Section Access

rido1421 — Thu, 21 May 2015 07:43:51 GMT

Hi Avinash.

Im not sure how I would give a sample of the model it is a bit complex.

The field names that I am trying to restrict, COST_CENTRE and CODE_2 , Does it have to come from the fact table or is there any specific requirement with regards to these fields.

I have just taken the fields as is and tried to limit access.