3 Replies Latest reply: Feb 5, 2014 4:57 PM by j i RSS

    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_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

      [H:\Documents\QlikView\Simple examples\Section Access\SectionAccessExampleData.xlsx]

      (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