Data reduction based on logged-in user

VinayakAthalekar — Wed, 07 Sep 2022 13:34:47 GMT

I am following the https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm filter the data based on the logged in user. Observation is that Azure AD users and Groups are synced with Qlik Sense after IdP integration.

Added users and Groups to Shared Space. But observation is that if I try to refer the AD group or email address it is not loading data based on the provided condition with user.

Data:

LOAD *

inline

[

YEAR, COUNTRY, SALES

2022,USA,100

2021, USA, 90

2020, USA, 10

2022, INDIA,100

2021, INDIA,90

2020, INDIA,80

2022,UK, 100

2021,UK,90

2020,UK,10

2022,AUSTRALIA, 100

2021, AUSTRALIA,90

2022, AUSTRALIA,80

];

section Access;

SA_TABLE:

Load

ACCESS,

USERID,

USER.GROUP,

USER.EMAIL,

COUNTRY,

COUNTRY as COUNTRY_SA

Inline

[

ACCESS,USERID, USER.GROUP, USER.EMAIL,COUNTRY

USER,*, *,VINAYAK.ATHALEKAR@abc.COM,USA

ADMIN,*,*,VINAYAK.ATHALEKAR@xyz.COM,*

];

Concatenate(SA_TABLE)

LOAD * where Not exists(COUNTRY_SA);

Load Distinct

'USER' as ACCESS,

'DUMMY' as USERID,

COUNTRY,

COUNTRY as COUNTRY_SA

Resident Data;

section Application;

Am I missing something?

topic Data reduction based on logged-in user in Integration, Extension & APIs

Data reduction based on logged-in user