topic Re: Restrict data based on user role in Integration, Extension & APIs

Restrict data based on user role

Anonymous — Fri, 13 Feb 2015 15:58:34 GMT

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.

Re: Restrict data based on user role

Sat, 14 Feb 2015 20:31:34 GMT

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/Dynamic%20data%20reduction.htm

Re: Restrict data based on user role

Anonymous — Tue, 10 Mar 2015 12:10:53 GMT

The link is broken can you provide updated link?

Re: Restrict data based on user role

Tue, 10 Mar 2015 12:30:52 GMT

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

Re: Restrict data based on user role

Anonymous — Wed, 11 Mar 2015 15:16:45 GMT

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.

Re: Restrict data based on user role

Fri, 27 May 2016 00:22:34 GMT

Hello,

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