The problem is that the ADMIN account that suppose to display ALL districts:
Is displaying only districts that are listed under other REDUCTION section for other users!!
Yes, that's what * means: all listed values. If you want all values instead of all listed values the leave it blank. This has not changed. It's been implemented this way for ages in Qlikview and works just the same in Qlik Sense. This is documented in the online help:
A wildcard, *, is interpreted as all (listed) values of this field, that is. a value listed elsewhere in this table. If used in one of the system fields (USERID, GROUP) in a table loaded in the access section of the script, it is interpreted as all (also not listed) possible values of this field.
Thank you for reply. I've replaced the wildcard with the blank and it works for ADMIN account...
But, do you know why "blank" field does not work for USER level account?
I've updated the code above as:
USER, SERVER\ALEX.CCCCCCCC, ,
And I've got the "Access Denied" message when trying to log-in to the application....
The app was published to the stream and this user has access to it.
Making this user an ADMIN works...
BTW, I did interpreter the help topic differently:
"( wildcard, *) If used in one of the system fields (USERID, GROUP) in a table loaded in the access section of the script, it is interpreted as all (also not listed) possible values of this field."
So my understanding was that all (also not listed) values should be displayed .....
I cannot check the QlikView files at this moment, but I will try to get to my old files to validate it in QV.