Simple section access

[#1]

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

[jvitantonio]

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.

JV

[vikasmahajan · Accepted solution]

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

[#4]

Daniel,

Fields must be UPPERCASE

=> write REGION everywhere

Fabrice