Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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:
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.
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.