topic Re: restrict one country using section access in qlik sense for few users in App Development

restrict one country using section access in qlik sense for few users

paulwalker — Mon, 23 Sep 2024 18:23:41 GMT

Hi Community,

SECTION ACCESS;

LOAD * INLINE [
ACCESS,USERID,COUNTRY
ADMIN,INTERNAL\SA_SCHEDULER,
USER,User1,
USER,User2,PAK
USER,User3,IND
USER,User4,
USER,User5,AUS
];

Section Application;

This code is working fine for all the users, but here User1 need to exclude NZ (New Zealand) country.

User4 has to see all the countries including NZ.

is there any way to restrict?

Thanks in Advance!

Re: restrict one country using section access in qlik sense for few users

David_Friend — Mon, 23 Sep 2024 18:21:27 GMT

Add a country field and then do -NZ for user1

SECTION ACCESS;

LOAD * INLINE [
ACCESS, USERID, PRODUCT, COUNTRY
ADMIN, INTERNAL\SA_SCHEDULER, *,
USER, User1, *, -NZ
USER, User2, PAK, *
USER, User3, IND, *
USER, User4, *, *
USER, User5, AUS, *
];

SECTION APPLICATION;

Re: restrict one country using section access in qlik sense for few users

paulwalker — Wed, 25 Sep 2024 09:30:26 GMT

Is there any way to restrict one country for specific users?

Please let me know if it is possible or not?

Re: restrict one country using section access in qlik sense for few users

David_Friend — Wed, 25 Sep 2024 11:49:47 GMT

@paulwalker did you check your question using ChatGPT etc. SA can be pretty tricky, I am not an expert on it by any means!

Re: restrict one country using section access in qlik sense for few users

Kushal_Chawda — Wed, 25 Sep 2024 13:32:55 GMT

@paulwalker easy way would be to create individual country record for user1 to get access to specific country excluding NZ. Make sure that all field values of all columns in section access are in upper case.

SECTION ACCESS; data: LOAD * INLINE [ ACCESS,USERID,COUNTRY ADMIN,INTERNAL\SA_SCHEDULER, USER,User1, USER,User2,PAK USER,User3,IND USER,User4, USER,User5,AUS USER,User6,NZ ]; Final: NoConcatenate Load * Resident data where USERID<>'User1'; Concatenate(Final) Load distinct ACCESS, 'User1' as USERID, COUNTRY Resident data Where COUNTRY<>'NZ' and len(trim(COUNTRY))>0; Drop Table data; Section application;