Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have used section access before. I have been following a tutorial (http://community.qlik.com/servlet/JiveServlet/previewBody/1853-102-2-3345/Introduction_to_Section_Ac...) to try to get used to the technique.
I have created a very simple script that I was hoping to get the basics of security sorted with.
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, Region
ADMIN, ADMIN, ADMIN
USER, USER1, U1, AFRICA,
USER, USER2, U2, ASIA,
USER, USER3, U3, EUROPE,
USER, USER3, U3, AMERICA
];
Section Application;
LOAD Region,
TransactionID
FROM
(ooxml, embedded labels, table is Sheet1);
I was hoping that when I logged in as Admin I would see everything, when I logged in as USER1 I would see only Africa etc. However it seems regardless of who I login with I see everything.
I have gone to Setting -> Document properties -> Opening and ticked 'Initial Data Reduction Based on Section Access' but this still doesn't seem to make it work.
Any suggestions would be greatly appreciated.
Thanks
Dan
While loading from excel take upper in your script this should work
Upper(Region),
Also find some documents will help you to implement section access.
Good luck.
Vikas
Hi Daniel,
Make everything upper case. like this:
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, upper(Region) as Region
ADMIN, ADMIN, ADMIN
USER, USER1, U1, AFRICA,
USER, USER2, U2, ASIA,
USER, USER3, U3, EUROPE,
USER, USER3, U3, AMERICA
];
Section Application;
LOAD upper(Region) as Region,
TransactionID
FROM
(ooxml, embedded labels, table is Sheet1);
I hope this helps.
While loading from excel take upper in your script this should work
Upper(Region),
Also find some documents will help you to implement section access.
Good luck.
Vikas
Daniel,
Fields must be UPPERCASE
=> write REGION everywhere
Fabrice