Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

Section access in Qlik sense

Hi All,

We are getting uers from AD.Could you please how to apply section access for AD users.

How to we apply the roles please assist me.

Thanks

5 Replies
kishorj1982
Creator II
Creator II
Author

Hi All,

We have users assigned to respective group.

instead of users level we need to implement section access on gorup level.

Could you please suggest how do we implement section access on group level.

it would be better if you could share 1 example with me.

We have format as per below.

   

USERIDTYPEVALUE
CABTEST\svc_cdpadminGROUPadmin
AP\tibhedeeGROUPQlik Sense User

   

USERIDNAME
AP\tibhedeeTibhe Deepak
CABTEST\svc_cdpadminService Account

Thanks.

praveenkumar_ma
Partner - Creator
Partner - Creator

Hi  Kishor,

This might Help you ..

Example: Data reduction based on user groups

section access;

LOAD * inline [

ACCESS, USERID, GROUP, REDUCTION, OMIT

USER, *, ADMIN, *,

USER, *, A, 1,

USER, *, B, 2, NUM

USER, *, C, 3, ALPHA

USER, *, GROUP1, 3,

ADMIN, INTERNAL\SA_SCHEDULER, *, *,

];

section application;

T1:

LOAD *,

NUM AS REDUCTION;

LOAD

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

RecNo() AS NUM

AUTOGENERATE 3;

The result will be:

  • Users belonging to the ADMIN group are allowed to see all data and all fields.
  • Users belonging to the A group are allowed to see data associated to REDUCTION=1 across all fields.
  • Users belonging to the B group are allowed to see data associated to REDUCTION=2, but not in the NUM field
  • Users belonging to the C group are allowed to see data associated to REDUCTION=3, but not in the ALPHA field
  • Users belonging to the GROUP1 group are allowed to see data associated to REDUCTION=3 across all fields
  • The user INTERNAL\SA_SCHEDULER does not to belong to any groups but is allowed to see all data in all fields.

    The wildcard, character *, in this row refers only to all values within the section access table. If there are values in the section application that are not available in the REDUCTION field in section access, they will be reduced.

Thanks

PM

kishorj1982
Creator II
Creator II
Author

Hi Praveen,

Thanks for the response.

We have scenario as per below,

We have 3 kind of Customers,

Secret Customers

Mega Customers

General Customers.

Secret Customers should have an access for Secret Customers group as well as General Customers

Mega Customers should have an access for Mega Customers group as well as General Customers.

And for only General Customers  access Secret and Mega Customer group is not visible.

Could you please suggest how to apply section access(Document level,Object level,Field level,Column level) in qlik sense based on above scenario's

Thanks

kishorj1982
Creator II
Creator II
Author

Hi,

This is not working

Thanks