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

SECTION ACCESS;

LOAD [ACCESS],

     USER,

     [PASSWORD],

     NTNAME

FROM

C:\Users\fshanaghy\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

is the code

I am clearly not awake today....

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

to get your code to work i had to put * in NTNAME too for the ADMIN login. I can get your QVW to work with my NTNAME now, but can't get my QVW to work. The difference is that i am using an inline statement AND spreadsheet to create my security table.

Not applicable

Yea it seems a little buggy, can you avoid using an inline since you are loading the spreadsheet anyway?  Or store them into a QVD first and load the QVD with the combined access?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

I think i will try that and see how it goes. Thanks for your help on this.