Section Access - 2 Fields or more

madnanansari — Thu, 24 Nov 2016 12:25:50 GMT

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)

Re: Section Access - 2 Fields or more

Thu, 24 Nov 2016 13:25:57 GMT

Please have a look at this article: Data Reduction Using Multiple Fields

Although it was written with QlikView in mind, it will be of value to you as well.

topic Re: Section Access - 2 Fields or more in App Development

Section Access - 2 Fields or more

Re: Section Access - 2 Fields or more