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:
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:
Item Master (Item, Category, brand)
Store Master (Store, Region)
Sales (Item, Store, Qty, Price)