Data reduction based on logged-in user

[VinayakAthalekar]

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?