topic Re: Section Access ...( ensures that each department has access to its partition only ) in App Development

Section Access ...( ensures that each department has access to its partition only )

Ahmed_Hussein — Sat, 16 Nov 2024 04:05:58 GMT

I have a query please if I created an application that includes Dashboard to facilitate the presentation and analysis of data from an Excel file containing information pertaining to all employees in all departments of the company and I want to share the application with the heads of departments across Qlik Sense Cloud so that each head of the department sees only the department assigned for him and does not see the rest of the departments. Note that the Excel file contains many columns and rows and that the department column contains all departments in the same file. Can I apply this idea in one application in Qlick Sense ... ensures that each department has access to its partition only ...

Re: Section Access ...( ensures that each department has access to its partition only )

JordyWegman — Wed, 20 Nov 2019 08:40:45 GMT

Hi Ahmed,

It not supported in the Qlik Sense Cloud.

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm

What you can do is create multiple apps, but only assign the app to the particular group.

Jordy

Climber

Re: Section Access ...( ensures that each department has access to its partition only )

Ahmed_Hussein — Wed, 20 Nov 2019 08:58:23 GMT

Thank you so much, Are you sure there is no way to solve such problems in Qlick Sense enterprise

Re: Section Access ...( ensures that each department has access to its partition only )

JordyWegman — Wed, 20 Nov 2019 09:07:43 GMT

You can solve this with Qlik Sense Enterprise, that is not a problem.

Jordy

Climber

Re: Section Access ...( ensures that each department has access to its partition only )

Ahmed_Hussein — Wed, 20 Nov 2019 10:18:02 GMT

Ok thank you, Could you tell me that the mechanism or method to do that ...

Re: Section Access ...( ensures that each department has access to its partition only )

JordyWegman — Wed, 20 Nov 2019 10:59:19 GMT

Of course, check my link above. This is also an example:

Example: 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; The field REDUCTION (upper case) now exists in both section access and section application (all field values are also upper case). The two fields would normally be totally different and separated, but using section access, these fields are linked and the number of records displayed to the user is reduced. The field OMIT, in section access, defines the fields that should be hidden from the user.

The result will be:

User ADMIN can see all fields and only those records other users can see in this example when REDUCTION is 1,2, or 3.
User A can see all fields, but only those records associated to REDUCTION=1.
User B can see all fields except NUM, and only those records associated to REDUCTION=2.
User C can see all fields except ALPHA, and only those records associated to REDUCTION=3.

Jordy

Climber

Re: Section Access ...( ensures that each department has access to its partition only )

Ahmed_Hussein — Wed, 20 Nov 2019 11:16:30 GMT

Thank you so much, Jordy Can I have your user name on Instagram or anything I can communicate with you easily

Re: Section Access ...( ensures that each department has access to its partition only )

JordyWegman — Wed, 20 Nov 2019 11:50:54 GMT

No problem, I don't have any social media accounts. You send a PM via the Qlik Community if you want.

Jordy

Climber