1 Reply Latest reply: Nov 24, 2016 8:25 AM by Thomas Friebel RSS

    Section Access - 2 Fields or more

    Mohammad Adnan Ansari

      I am working on a retail system. The retail company has different regions where stores are located. Let's say the regions are New York, Seatle & Los Angles.

       

      I need to provide the user access to regional managers as well as the store manager. Regional Managers need full access to the Regions sales information whereas the store managers can look at their stores only.

       

      When I define this access in Qlik Sense; it dont give me accurate results. The below is the setting for the section access:

       

      section access;

      LOAD * inline [

      ACCESS, USERID, REGIONID, UNITID, OMIT

      ADMIN, QLIKS\QLIKSENSE, *, *,

      USER, QLIKS\JOHN, NEWYORK, *,

      USER, QLIKS\PETER, NEWYORK, JW010,

      ADMIN, INTERNAL\SA_SCHEDULER, *, *,

      ];

       

      when I run the dashboards to test the access: for user QLIKSENSE it show all data.

       

      For user JOHN it shows all data. (This is wrong).

       

      For user PETER it shows only store (JW010) data.

       

       

       

      I have to define category managers and brand managers access as well which is secondary job. Vendors are also waiting for an access to there inventory.

       

      Pls. let me know how to overcome this issue.

       

      I have the below tables in my model:

       

      Master Calendar

      Item Master (Item, Category, brand)

      Store Master (Store, Region)

      Sales (Item, Store, Qty, Price)