Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jasmeenkr
New Contributor

Section Access

Hi All,

I am trying to apply section access to two fields (combined as Composite key) but getting error and data loads takes time in hours.

Any pointers how to achieve it ?

Two fields on which section access to be applied - Products and Categories

I want section access to work in way that when i select Product only listed categories in section access should display for particular user

4 Replies
wsxedcwsx
Contributor

Re: Section Access

It is not quite clear. Can share your code?

jasmeenkr
New Contributor

Re: Section Access

I am trying to code something like this:

Section Access;

Load *  inline

[

ACCESS  ,USERID  ,PRODUCTID,CATEGORIES, OMIT

];

I have to limit Categories as per following:

User a can see only PRODUCT A and only one of the category below

User b can see all categories under product a

vunguyenq89
Contributor

Re: Section Access

You need to explicitly populate all combinations of reduction field values that you want each end-user to see. Let say you have 3 Categories A1,A2,A3 under PRODUCT A. Your Section Access table (for Qlik Sense) should be:

Section Access;

Load *  inline

[

ACCESS  ,USERID  ,PRODUCTID,CATEGORIES, OMIT

ADMIN, INTERNAL\SA_SCHEDULER,,,

USER, UserA, PRODUCT A, A1,

USER, UserB, PRODUCT A, A1,

USER, UserB, PRODUCT A, A2,

USER, UserB, PRODUCT A, A3,

];

Section Access table is no special than other tables in your data model except for the fact that it is hidden from users. If your reload takes long time, Section Access isn't likely to be the cause.

If you still get error, some screencaps of the error messages should be helpful.

dwforest
Valued Contributor

Re: Section Access

What error?

What does the detail for your section access records look like?

How much data?

What's the load time without Section Access?