topic Re: Section Access using NTName Issue in QlikView

Section Access using NTName Issue

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We have section access on our document, so that each user can see their own data. Below is the script:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, [NAME]

ADMIN, Domain\Userid, 'user'

ADMIN, Qservice, *

];

Section Application;

the NAME is linked to a table in our data model.

The issue when we try to access the file through access point it gives us an error 'Failed to Open the document'. we are using SR5.

is there some wrong that I am doing? Any help?

Thanks

Re: Section Access using NTName Issue

maxgro — Thu, 04 Sep 2014 17:52:20 GMT

use uppercase for section access field, remove quotes

some detail here

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

and in the attached pdf

Re: Section Access using NTName Issue

Thu, 04 Sep 2014 18:03:10 GMT

Thanks. I looked through this document.

Do the values in the fields have to be uppercase? I tried removing the quotes also. still same error.

Re: Re: Section Access using NTName Issue

maxgro — Thu, 04 Sep 2014 18:22:38 GMT

I always use uppercase

You can use the small doc attached (User ID is user) to try lower/uppercase

Re: Section Access using NTName Issue

Thu, 04 Sep 2014 18:48:54 GMT

Thanks. Tried upper case and lower case. Still same error "Failed to open the document" when i open it through access point

Re: Section Access using NTName Issue

Fri, 05 Sep 2014 08:48:15 GMT

what if you put a star instead of a value in the NAME field.

Do you have strict exclusion on the document?

Re: Section Access using NTName Issue

Bill_Britt — Fri, 05 Sep 2014 12:39:38 GMT

Hi Padmaja,

Try just using the basic at first to make sure you can get into the document before you start the data reduction.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, Domain\NTNAME

ADMIN, Qservice, *

];

Section Application;

Bill

Re: Section Access using NTName Issue

Fri, 05 Sep 2014 16:35:07 GMT

I tried using star also...but not able to view through access point.

Thanks Bill...have not tried the basic section access..will try that...

Re: Section Access using NTName Issue

Fri, 05 Sep 2014 20:53:06 GMT

Bill,

I tried with basic section access and I am able to get in. But the moment i put in data reduction, it gives an error. This is my script

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, ACCESSID

ADMIN, Domain\NTNAME, ID

USER, Domain\NTNAME, ID

ADMIN, Qservice, *

];

Section Application;

Thanks

Re: Section Access using NTName Issue

Bill_Britt — Fri, 05 Sep 2014 21:09:32 GMT

What do you have ACCESSID tied to under Section Application?

Bill

Re: Section Access using NTName Issue

Fri, 05 Sep 2014 21:18:01 GMT

ACCESSID is tied to the username under section application and the username is linked to user column in our data model. The basic idea is that-each user must see their own data.

like this:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, ACCESSID

ADMIN, Domain\NTNAME, ID

USER, Domain\NTNAME, ID

ADMIN, Qservice, *

];

Section Application;

LOAD * INLINE [
ACCESSID, [USER NAME]

ID1, 'lastname, firstname'

ID2, 'lastname, firstname];

But my usernames have blank spaces in each name. Will that cause any issue?

Padmaja