Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Access using NTName Issue

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, 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

10 Replies
Not applicable
Author

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