Problem with Section access

[ali_hijazi]

Hello

we have Qlik Sense server latest version
on a dashboard we defined section access (some users have ADMIN access and others with USER access)
there is an expression: sum(Expected_Man_Days)
this expression gives zero when some users with USER access access the dashboard and this is wrong:
However if I remove the section access and I reload the dashboard and then on the UI I select the UserID of the user the expression gives a correct number

so the expression is not working fine when section access is applied

[manoranjan_d]

Have you added any omit field in the section access?

[ali_hijazi]

Yes some fields are omitted for some users but this particular user the omit is kept blank 

So the omit is giving problems?

[manoranjan_d]

So the omit is giving problems?

yes, only for admin only you pass it as blank.

example for omit

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, OMIT
ADMIN, ADMIN, ADMIN,
USER, USER1, U1, SALES
USER, USER2, U2, WAREHOUSE
USER, USER3, U3, EMPLOYEES
USER, USER4, U4, SALES
USER, USER4, U4, WAREHOUSE
USER, USER5, U5, *
];
Section Application;
LOAD * INLINE [
SALES, WAREHOUSE, EMPLOYEES, ORDERS
1, 2, 3, 4
];
In this example, the field OMIT has been added as part of Section Access.
USER1 will not be able to see the field SALES, USER2 will not be able to see field
WAREHOUSE and USER3 will not see field EMPLOYEES.
USER4 has been added twice to the solution since we want to OMIT two fields for this
user, SALES and WAREHOUSE.
USER5 has a “*” added which means that all listed fields in OMIT will be unavailable.
USER5 will not be able to see fields SALES, WAREHOUSE and EMPLOYEES.

[ali_hijazi]

So if a user doesn't see a field f1 and there is a measure related to f1 then the sum of that measure would be zero?

[manoranjan_d]

So if a user doesn't see a field f1 and there is a measure related to f1 then the sum of that measure would be zero?

Yes, it will be zero or null value 

[ali_hijazi]

today I removed the OMIT from section access and still that user sees zero as the result of the expression while admins see the result correctly

kindly advise

[manoranjan_d]

Can you share your section access script

[ali_hijazi]

section Access;

/*
project managers
*/
security:
LOAD
ACCESS,
USERID,
SECURITY_KEY
FROM [$(vG.LoadPath)SECURITY_PRJ_MANAGER.qvd]
(qvd);

/*
admins / super users
*/
Concatenate(security)
Load
ACCESS,
USERID
from [$(vG.LoadPath)SECURITY_ADMIN_LIST.qvd](qvd);
/*
FPNA Users
*/
Concatenate(security)
LOAD
USERID,
ACCESS,
SECURITY_KEY
FROM [$(vG.LoadPath)SECURITY_NON_ADMIN_FPNA_PROJECT_TP2.qvd]
(qvd);
Concatenate(security)
LOAD
USERID,
ACCESS,
SECURITY_KEY
FROM [$(vG.LoadPath)SECURITY_NON_ADMIN_FPNA_RESOURCE.qvd]
(qvd);
/*
bu list
*/
Concatenate(security)
LOAD
USERID,
ACCESS,
SECURITY_KEY
FROM [$(vG.LoadPath)SECURITY_NON_ADMIN_BU_PROJECT.qvd]
(qvd);
Concatenate(security)
Load
USERID,
ACCESS,
SECURITY_KEY
FROM [$(vG.LoadPath)SECURITY_NON_ADMIN_BU_RESOURCE.qvd]
(qvd);
/**************************************************************************************************************/

/*
omit list for prj managers
*/
LOAD
USERID,
SubField(OMIT,',') AS OMIT
FROM [$(vG.LoadPath)SECURITY_PRJ_MANAGER_OMIT_LIST.qvd]
(qvd);
/**************************************************************************************************************/

[ali_hijazi]

can you join on Teams?
this way we make a quick call and I show you how the expression is behaving?