Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

lokeshwer
New Contributor

Restrict data based on user role

I created a qliksense dashboard and I need to restrict or filter the data based on user role. I understand that I can publish dashboard to streams but I don't want to maintain multiple dashboards.

I have sales dashboard with Region dimension containing East and West as possible values. I want user A to see only East region data and user B to see only West region data and user CEO should be able to see all regions. I don't want to create dashboards with different dataset. It would be great to have single dashboard and restrict the data using custom extensions.

Is this possible with extensions? Please show me some pointers to filter data.

1 Solution

Accepted Solutions
Not applicable

Re: Restrict data based on user role

Hi,

I haven't tried this my self but this is what the help says.

Dynamic data reduction

Qlik Sense supports the dynamic data reduction feature, by which some of the data in an app can be hidden from the user, based on the section access login:

  • Fields (columns) can be hidden by using the system field OMIT.
  • Records (rows) can be hidden by linking the section access data with the real data: The selection of values to be shown/excluded is controlled by having one or more fields with common names in section access and section application. After user login, Qlik Sense will attempt to copy the selections in fields in section access to any fields in section application with exactly the same field names (the field names must be written in UPPER CASE). After the selections have been made, Qlik Sense will permanently hide all data excluded by these selections from the user.

https://help.qlik.com/sense/en-us/online/#../Subsystems/WorkingWith/Content/Scripting/Security/Dynam...

5 Replies
Not applicable

Re: Restrict data based on user role

Hi,

I haven't tried this my self but this is what the help says.

Dynamic data reduction

Qlik Sense supports the dynamic data reduction feature, by which some of the data in an app can be hidden from the user, based on the section access login:

  • Fields (columns) can be hidden by using the system field OMIT.
  • Records (rows) can be hidden by linking the section access data with the real data: The selection of values to be shown/excluded is controlled by having one or more fields with common names in section access and section application. After user login, Qlik Sense will attempt to copy the selections in fields in section access to any fields in section application with exactly the same field names (the field names must be written in UPPER CASE). After the selections have been made, Qlik Sense will permanently hide all data excluded by these selections from the user.

https://help.qlik.com/sense/en-us/online/#../Subsystems/WorkingWith/Content/Scripting/Security/Dynam...

lokeshwer
New Contributor

Re: Restrict data based on user role

The link is broken can you provide updated link?

Not applicable

Re: Restrict data based on user role

Try using the Qlik Help at help.qlik.com.

lokeshwer
New Contributor

Re: Restrict data based on user role

Search in help page doesn't provide the link.

Google search on your site provided the correct link.

Now, I tried this on the dashboard I created with following script

section access;

LOAD * inline [

ACCESS, USERID,REDUCTION, OMIT

USER, domain\ADMIN,1,

USER, domain\lbabu,2,

USER, INTERNAL\SA_SCHEDULER,*,

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

    Project,

    Site,

    Market,

    Technology,

    RecNo() AS NUM

FROM [lib://Sample (domain_lbabu)/Sample.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

This returns all records. Any pointers?

P.S: The demo script in the help works.

Not applicable

Re: Restrict data based on user role

Hello,

I have similar requirement, so wondering whether you got any solution for this problem ??

Community Browser