I am following the https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manag... 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?