Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Simple section access

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

1 Solution

Accepted Solutions
vikasmahajan
Esteemed Contributor

Re: Simple section access

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

View solution in original post

3 Replies
Luminary
Luminary

Re: Simple section access

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
Esteemed Contributor

Re: Simple section access

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

View solution in original post

Not applicable

Re: Simple section access

Daniel,

Fields must be UPPERCASE

=> write REGION everywhere

Fabrice