Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pradnya_amol
Creator
Creator

Replace Field content by "***" using Section Access different Users based on their NTID

Hello All,

Hope you all are safe in Lock Down!

I have a situation where my EAME Clients should see there EmpID and EmpName in "******" instead of Full ID and Name while for the rest these fields can be visible.

Needful fields from the Sample Data from the QVD:-

EMPID, EmpName, Region, CountryCode

E101,       Pradnya,   APAC, IN

E102,       Salman,   APAC, IN

E103,       Shahid,      EAME, FR

E104,       Ananya, EAME, HU

E105,       Alia,     EAME, FR

E106,       Aditya,  LATAM, PA

];

Section Access Code which I'm currently using in the Dashboard:-

TECC:
LOAD
ACCESS,
USERID,
Upper(Region) &'-'& Upper("Employee Country Code") as Region_Code_Key
FROM [lib://SharedFolder/Concur Excel/New Data/T&E Section Access.xlsx]
(ooxml, embedded labels, table is [PROD SA List]);

Concatenate(TECC)
LOAD Distinct 'DUMMY' as USERID,
Region_Code_Key
Resident Key;

SECTION Access;
STAR is *;
LOAD Distinct Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Region_Code_Key

Resident TECC;
SECTION Application;

DROP Table TECC;

EXIT SCRIPT

Sample from Excel File used for section access:-

ACCESSUSERIDRegionEmployee Country Code
USER APAC\s1005229APACIN
USERAPAC\u897130APACIN
USEREAME\S952204EAMEFR
USEREAME\u971880EAME*
Labels (4)
1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary