Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Creator
Creator

how to gives access group level qlik sense section access

Hi ,

 

Can you give some example how to gives access group level qlik sense section access.

I have some requirement like below:

let's we have Total 6 user: They are divided into 2 Group.

How to Give access 2 group different level country access.

ex: 1st group need IND,USA access 

     2nd  group need UK,AUS access

I have provided the Data below

Sales:
Load * inline

[

Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300

2019, USA, 120
2020, USA, 220
2021, USA, 500

2019, UK, 350
2020, UK, 650
2021, UK, 150

2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];

3 Replies
Levi_Turner
Employee
Employee

You can define 2 reductions for a group. Example from Qlik Cloud:

Section Access;
LOAD * INLINE [
ACCESS,	USERID,			GROUP,		COUNTRY
ADMIN,	QLIK-POC\LTU,	*,			*
USER,	*,				GROUP1,	IND
USER,	*,				GROUP1,		USA
USER,	*,				GROUP2,		UK
USER,	*,				GROUP2,		AUS
];	

SECTION APPLICATION;

Sales:
Load * inline
[
Year, COUNTRY,Sales
2019, IND, 100
2020, IND, 200
2021, IND, 300
2019, USA, 120
2020, USA, 220
2021, USA, 500
2019, UK, 350
2020, UK, 650
2021, UK, 150
2019, AUS, 850
2020, AUS, 750
2021, AUS, 450
];

 (if using Qlik Sense Enterprise - Client Managed, you will want to add in INTERNAL\SA_SCHEDULER ref).

 

for user with GROUP1:

Levi_Turner_0-1713386457619.png

 

Naps_230
Creator
Creator
Author

Hi Turner,

How to created two group, and  how Group field is link to section access table.

Could you please give details, it will be helpful for me.

Levi_Turner
Employee
Employee

Groups are fetched either from the configured authentication provider (Qlik Sense Enterprise Client Managed or Qlik Cloud) or from a configured User Directory Connector (Qlik Sense Enterprise Client Managed). You brought up groups as the technique which you wanted to use for reduction. You can use USERID if groups aren't available.

Section Access is an authorization table. The GROUP column is associated to the data table(s) by the REDUCTION field joining with the model (field = COUNTRY in this example) like any other table in Qlik.