Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
kev6brown
Partner - Creator
Partner - Creator

Section Access

I have the following section access script in my hidden script - 

Section Access;


LOAD * INLINE [
ACCESS,  NTNAME,              OMIT,       SLRLEVEL8,    SLRLEVEL7
ADMIN,     DOMAIN\USER1,   *,             *,                       *
ADMIN,     DOMAIN\USER2,   *,             *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       EMERGENCY DENTAL SERVICE
ADMIN,     DOMAIN\USER3,   NHSNO,  *,                       SPECIAL CARE DENTAL SERVICE
];

Section Application;

 

When opening the dashboard my log in - DOMAIN\USER1, I can only see EMERGENCY DENTAL SERVICE and SPECIAL CARE DENTAL SERVICE and cannot see NHSNO.

 

Why is this happening? I should be able to see everything

 

Thanks

 

Kev

Labels (1)
10 Replies
TauseefKhan
Creator III
Creator III

Hi @kev6brown,

This could be because:

• The * in SLRLEVEL7 is not being interpreted as "all data". Instead, it's being treated as a literal value.

• There might be a conflict with other user settings, especially if multiple entries for the same user exist with different access rights.

• There could be an issue with how the data model is set up, affecting the data reduction process.

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

kev6brown
Partner - Creator
Partner - Creator
Author

Any idea how I change it so it does interpret it as "All Data"?

 

TauseefKhan
Creator III
Creator III

 * wildcard in Section Access is interpreted as "All Data," you need to make sure that the reduction fields (SLRLEVEL8, SLRLEVEL7, etc.) are properly linked to your data model.


kev6brown
Partner - Creator
Partner - Creator
Author

I've removed SLRLEVEL7 and anything in OMIT. So just SLRLEVEL8 is being reduced, however it is still not working, even though it does link in the data model

BrunPierre
Partner - Master
Partner - Master

DOMAIN\USER1 has a "*" added, indicating that all fields listed in OMIT will be hidden.

If you want this user to see the field NHSNO, leave the OMIT value blank.

kev6brown
Partner - Creator
Partner - Creator
Author

I have removed OMIT from the table so it now looks like - 

 

Section Access;
 
Access:
LOAD * INLINE [
ACCESS,      NTNAME,                  SLRLEVEL8
ADMIN,          DOMAIN\USER1,     *
ADMIN,          DOMAIN\USER2,     CARER HEALTH TEAM
ADMIN,          DOMAIN\USER3,     OVERNIGHT SERVICE COASTAL
];
 
Section Application;
 
I'm now seeing CARER HEALTH TEAM and OVERNIGHT SERVICE COASTAL when i should see everything
BrunPierre
Partner - Master
Partner - Master

In Section Access, the "*" character in a reducing field represents only the values listed in Section Access, not any additional values in the data. 

Star is *;

Section Access;

Access:
...

kev6brown
Partner - Creator
Partner - Creator
Author

Ok that makes sense, so if I want to be able to see all values do I just leave SLRLEVEL8 blank for me?

BrunPierre
Partner - Master
Partner - Master

This thread has multiple scenarios: Managing data security with Section Access