Section Access does not work for USER (ACCESS) and * values.

[vishal_goyal]

Hi, 

I am facing a strange issue while applying Section access in my QlikSense App.

I want userA to have access to all clients while userB restricted to a specific client. 

When i provide all values of reduction field for userA in each row of section access script , it works fine. However when i appply * it starts misbehaving and filters only to reduction value of userB. 

Example:

I have only 3 distinct values for my data model field SA_PART_SHORT_NAME (JPMC,BARC and CAM). Below section script works fine for both userA and userB. 

Section Access;
Load * inline [
ACCESS, USERID, SA_PART_SHORT_NAME
USER, INFOCLOUD\userA, JPMC

USER, INFOCLOUD\userA, BARC

USER, INFOCLOUD\userA, CAM 

USER, INFOCLOUD\userB, BARC
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;

However, when I change it to below, userA start giving me data only for BARC instead of all 3 values 

Section Access;
Load * inline [
ACCESS, USERID, SA_PART_SHORT_NAME
USER, INFOCLOUD\userA, *

USER, INFOCLOUD\userB, BARC
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;

Am I missing something when trying to use * for userA ? 

Thanks 

[Lisa_P · Accepted solution]

The * will only represent the other values in the table.

So in SA Table 1, the SA_PART_SHORT_NAME values are JPMC, BARC, CAM 

in SA Table 2, the only SA_PART_SHORT_NAME value is BARC

[vishal_goyal · Accepted solution]

That really helps... I was under impression that * denotes all possible values in Data Model.