Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
roebrich
Contributor III
Contributor III

Section Access Question - Overlapping access

Hi, I would like to know if this scenario is possible. 

Assume the following:

  • Extra rows were created above User1 for "Dummy" user that lists all possible values for Dim1 and Dim2
  • Dim1 and Dim2 have more values not listed in the sample below.
  • Below is how the section access table is written for User1

ACCESSNTNAMEDIM1DIM2

USER

User1*DIM2VALUE1
USERUser1*DIM2VALUE2
USERUser1*DIM2VALUE3
USERUser1DIM1VALUE1*

I know that here, User1 will have access to all values for DIM1 and DIM2. But what I would like to happen is that the user will have access to all DIM1 values related to DIM2 values 1-3, but for DIM1VALUE1 it should have access to all DIM2 values related to it. Like DIM1VALUE1 can have DIM2VALUE4, I want to be able to see that, but if DIM1VALUE2 also have DIM2VALUE4 I don't want to see that. Is this possible with section access? If not, do you have an advice to how security should be implemented here?

Thanks,

Roebrich Perez

0 Replies