topic Simple section access in QlikView

Simple section access

Mon, 03 Feb 2014 09:17:40 GMT

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_Access_-_Rev_1-1.p…) 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

Re: Simple section access

jvitantonio — Mon, 03 Feb 2014 09:38:15 GMT

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.

Re: Simple section access

vikasmahajan — Mon, 03 Feb 2014 10:07:37 GMT

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

Re: Simple section access

Mon, 03 Feb 2014 10:09:46 GMT

Daniel,

Fields must be UPPERCASE

=> write REGION everywhere

Fabrice