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

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.