I tried to reduce data via section access. it works like a charm for users with "USER" access, but it also reduces data for ADMINS so weird! like I have A as USER and B as ADMIN, A can see their own data and B(ADMIN) sees only the data of A.
here is my script(I have also ticked "Initial data reduction based on section access" in Document properties--> opening):
star is *;
section Access;
SQL SELECT ACCESS,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_TKN,
case when ACCESS = 'ADMIN' then '*' else `Moodle_USERID` END as USERID_CAP,
upper(USERID) as NTNAME,
'*' as PASSWORD,
'*' as USERID
FROM <MyUsersTable>;
concatenate
load * inline [ACCESS , USERID_TKN, USERID_CAP, NTNAME, PASSWORD, USERID
ADMIN, , , , 123, RELOADER
ADMIN, , , SRV-QVS\ADMINISTRATOR , * , *
];
section Application;
as you can see, I want to reduce data based on two fields (USERID_TKN , USERID_CAP)
QlikView
@Albert_Candelario
