Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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