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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Section Access help

Hi all,

I need some help with section access please. I have attached my files, I am loading in an inline table plus a security spreadsheet, but i can't get it to accept anything from the spreadsheet even though it IS loading the data into the QVW.

Can anyone help please?

23 Replies
Not applicable

I think it may be down to you having \ in your NTNAME you should have /

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

I have just tried that but it didn't work.

I am sure the \ is correct as this is what is returned when using osuser() in a text box..

NTNAME.JPG

Not applicable

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, NTNAME

    ADMIN, ADMIN, ADMIN,

    ADMIN, , , IP-0A3149BC/FSHANAGHY

];

Section Application;

this is working for me.... odd

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

I need it to work from the spreadsheet. Could it be to do with the * 's in the spreadsheet?

If i use the NTNAME in the inline table it works fine.

Not applicable

You should leave the * out in section access * means every forementioned value so just leave the value blank if you want all values.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, so you are saying that the spreadsheet shouldnt have any * 's in it at all?

Not applicable

Correct If you want all values they are not required

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, i removed the * 's but still no joy. it keeps asking for login details.

Not applicable

This appears to work, oddly you need * in the password (or alternatively a password) the * bypasses it

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Again,it didn't work for me, and i can't even open your QVW - Acess denied with no USERID prompt