Section access contained for departments in Qlik sense

[alespooletto]

Hello, I have this following section access script:

Section Access;

Star is *;

Load * INLINE [
    ACCESS, USERID, DATA
    ADMIN, *, *
    ADMIN, INTERNAL\SA_SCHEDULER, *
    ADMIN, ADMIN1, *
    USER, USER1, IT
    USER, USER2, HR

];

Section Application;

But it seems like people are not able to see anything. Am I missing another key field to connect this with ? 

[Ciya]

Hi, 

It seems you have missed domain name in the UserId. 
(domain name)\<userID>

[ift_isabelle]

Do you also have the DATA field in the fact table? And do they have the same values?

Are there other options then IT and HR?

[alespooletto]

I have other departments, yes, like AFC or OLS. The groups have an ID and the name in the facts table under the name TKT_Group. So ideally i should shart from changing the field name here from DATA to TKT_Group...

[ift_isabelle · Accepted solution]

Changing to field name is a good start.

Also notice what Ciya said about the domain. I don't know about cloud, but on premise the domain should be included.

Also note that if you only state these data lines:

    ADMIN, *, *
    ADMIN, INTERNAL\SA_SCHEDULER, *
    ADMIN, ADMIN1, *
    USER, USER1, IT
    USER, USER2, HR

Admin1 only sees IT and HR. * means "everything I described in my table", not "everything". 
According to the help, you should leave it empty to show everything, but I never got that working.

[alespooletto]

Thank you so much, I do have the domain active just not showing it here for privacy purposes. 

And I had no idea about that * thing. Interestingly, it also doesn't work for me if I leave it empty, as I can't see everything as I ought to ahaha