Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

madnanansari
New Contributor III

Section Access - 2 Fields or more

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)

1 Reply
Not applicable

Re: Section Access - 2 Fields or more

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.

Community Browser