Hi Guys,
I'm trying to configure Object (or chart) based security in QLIKVIEW using section access. Windows user ids are available in a Database table. Section access to provide access to QVW document for specified users works fine, But object access (For object TX01) is not working. User John should not see the object TX01. I referred Chart Level Access by user, but still not working.
Any help is much appreciated..
USERS:
LOAD
'ADMIN' as ACCESS,
'DOMAINNAME\'&UPPER(WINDOWSUSERID) as NTNAME;
SQL SELECT *
FROM UserAccess;
Section Access;
LOAD *
Resident USERS;
Section Application;
OBJ_ACCESS:
LOAD
NTNAME,
if(NTNAME='DOMAINNAME\JOHN',0,1) as TX01
Resident USERS;