Qlik Sense Section Access

[jasmeenkr]

Section Application mandatory field for giving section access in Qlik Sense

[shraddha_g]

Please elaborate your question with dummy data and expected output

[balabhaskarqlik]

Try like this:

If you create the app in Desktop, you'll need to import it into Qlik Sense using QMC.  If you create the app in QMC hub, there is no need to import.

Next, you publish the application in a Stream which is available for all users.User will see the part of the data which Section Access allows.

In Desktop, Section Access doesn't work, you see all data.

Section Access;

LOAD * inline

[

ACCESS,USERID

USER,U

USER1,U2

];

Section Application;

ABC:

LOAD

    *

from abc.csv;

OR

Data reduction based on user id

section access;

LOAD * inline

[

ACCESS, USERID,REDUCTION, OMIT

USER, AD_DOMAIN\ADMIN,*,

USER, AD_DOMAIN\A,1,

USER, AD_DOMAIN\B, 2,NUM

USER, AD_DOMAIN\C, 3, ALPHA

ADMIN, INTERNAL\SA_SCHEDULER,*,

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

Chr( RecNo()+ord('A')-1) AS ALPHA,

RecNo() AS NUM

AUTOGENERATE 3;

[jasmeenkr]

Thanks Bala for detailed explanation

One more thing I have requirement to display  limited categories under Product(I want to apply Section access on both categories and products).

Let me know how to achieve it.