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]

Hi ,

Pass your script between

section access ;

Section application;

You also need to pass one  more admin as below 

ACCESS,USEID

ADMIN,INTERNAL\SA_SCHEDULER,

Note: when you  are implementing section access it has to be upper case like above example i shared.

And same field should also be in upper in the data model or script

[ali_hijazi]

yes this is all done
the values in the table are all upper case and the security_key column contains numbers

and yes the SA_SCHEDULER is already part of the admin list
btw I've been working on Qlik for 10 years now
been working on Qlikview for long time and 3 years on Qlik Sense and this is the first time I encounter such a weird behavior

[manoranjan_d]

other than SA_SChCHEDULER, any thing you checked with qlik admin side to add in the section access

example 

ADMIN,INTERNAL\SA_API,

QAserviceaccount.

if again user is having zero for  filed then try to pass  blank value for omit and reduction.

[ali_hijazi]

I totally removed the OMIT part
and this user has values in the reduction
if I remove the section access command and I select the that user from USERID the expression gives correct number but when I apply the section access the expression returns zero for that user

for admins it is working just fine

[manoranjan_d]

Reduction will give the user to access only the data for specified data, where as OMIT will allow not to access the particular field value 

[ali_hijazi]

I know but the behavior is weird
at first I thought the omit is making issues 
but I removed the OMIT part from the script
I kept the reduction
but if I remove the section access line
then in the UI I can select the user from the USERID field and the expression gives me a number which is correct
but when I put back the section access line of code and I ask that user to open the dashboard after I publish it

the expression gives him zero

this is the weird behavior

[manoranjan_d]

yes its weird , better try this as last one

remove the particular  userid and run the section access and then

manually add the particular   userid details and then run it again with section access.

this is just a try only.