The * means all listed values, not all values. If you want the user to have access to all CUSTOMERID values then you should leave the entry blank.
If you have a table with userid's and the customerid's they are allow to access you can load that data into the section access table. It's probably wise to add a user with ADMIN access too:
LOAD * INLINE [
ACCESS, USERID, CUSTOMERID
'USER' as ACCESS,
userid as USERID,
customerid as CUSTOMERID
Everything I have read say that you only have a USER option and not ADMIN in Qlik Sense.
Also, I must be doing something wrong. When I leave the customerid blank for testuser1 then I get access denied when I try to login as them and access the app.
I tried it like this and with a , after testuser1 and both got access denied
Load * INLINE [
Well, a user with ADMIN access will have access to all the data in the app. That's certainly a reason not to give everybody that kind of access, but I reckon it's a good idea to have at least one user that has access to all the data in a document.
Perhaps section access works different in Qlik Sense also in other regards then Qlikview. Perhaps you need to explicitly set star to a value: Star ‒ Qlik Sense. So try adding a line Star is *; just before the section access table. Then using * should mean all values, instead of all listed values.
I've tried to use "blank" value instead of * and it does not work for showing "all values". Qlik Support confirmed that.
Using "Star is *;" statement did not help much..
I've ended up using pre-loaded table with "all values"
load * Inline [
ACCESS, USERID, REDUCTION, OMIT
And joining the table above into the Section Access table...
Looks like QS handles it differently than QV.
What has worked for me is to add one entry per customerId for an admin user. Lets say , the unique list of customerID's is 16,18,20, 22, 26, 40, 50
Load * INLINE [
Now, * will for testuser1