Section Access Qlik Sense "*" not working

[sudhi0092]

im trying to apply section access for data reduction. its not working for all access "*" and works for ADMIN and individual values.

Below reduction is working

ACCESS,USERID,LDAPGROUP,ENTITY_CODE
ADMIN,REG1\ILMASUPPORT,,*
ADMIN,INTERNAL\SA_REPOSITORY,,*
ADMIN,REG1\ILMAQSADMIN,,*

USER,REG1\USER1,GROUP1,ENTITY1

USER,REG1\USER1,GROUP2,ENTITY2

but below reduction is not working and show as "Access is Denied".

ACCESS,USERID,LDAPGROUP,ENTITY_CODE
ADMIN,REG1\ILMASUPPORT,,*
ADMIN,INTERNAL\SA_REPOSITORY,,*
ADMIN,REG1\ILMAQSADMIN,,*

USER,REG1\USER1,GROUP1,*

USER,REG1\USER1,GROUP2,*

[jonathandienst · Accepted solution]

The problem is that '*' does not mean all values in the data set. It means all the value explicitly added to the section access table. In you second set, you have no explicit values, so no-one has access to any ENTITY_CODE.

[sudhi0092]

Now i understand. Thank you 🙂

The column data we use comes from data feed and cannot hard code for all values.

All the values are also not available bcoz section access needs to be applied before loading the data (unless we temporarily read all values initially).

What would be the best approach for granting all value access to certain group? 

If we give 'ADMIN' role then cannot add data restriction for another column (say "LOCATION"). 

[hosur101]

Instead of "*" just leave it as blank. It will display all values.

[sudhi0092]

Leaving values as blank doesnot work.

[piyush_gaud]

Leaving values blank instead of * does works for me 🙂

[Ken_T]

how would someone get all the values for all the columns, and add them, so that the * would work in section access?  any suggestions on how to do that?