Qlik Sense Section Access

[piyush_s11]

Hi,

I have questions related to section access. I have below table

SECTION Access;

LOAD * INLINE [

ACCESS, USERID, REGION

ADMIN, PAT, ALL

USER1, CHRIS, SOUTHEAST ASIA

USER2, WILLIAM, NORTH ASIA

USER3, SAM, SOUTH ASIA

USER4, ERIN, MIDDLE EAST

];

SECTION Application;

Fact:

LOAD Upper(Region) as REGION, UPPER(Country) AS COUNTRY,* INLINE [

Region, Country, Sales

Southeast Asia, Brunei, 134

Southeast Asia, Cambodia, 93

Southeast Asia, East Timor, 128

Southeast Asia, Indonesia, 9

Southeast Asia, Laos, 10

Southeast Asia, Malaysia, 11

Southeast Asia, Myanmar, 13

Southeast Asia, Philippines, 80

Southeast Asia, Singapore, 3

Southeast Asia, Thailand, 34

Southeast Asia, Vietnam, 182

North Asia, China, 145

North Asia, Hong Kong, 7

North Asia, Japan, 412

North Asia, Macau, 3

North Asia, South Korea, 9

North Asia, Taiwan, 37

South Asia, India, 101

South Asia, Maldives, 3

South Asia, Sri Lanka, 3

Middle East, Bahrain, 8

Middle East, Lebanon, 17

Middle East, United Arab Emirates, 6

];

In this scenario what will be the access for ADMIN ?

Now if I change the access as below

LOAD * INLINE [

ACCESS, USERID, REGION

ADMIN, PAT, ALL

USER1, CHRIS, SOUTHEAST ASIA

USER2, WILLIAM, 

USER3, SAM, SOUTH ASIA

USER4, ERIN, MIDDLE EAST

];

In this scenari, what USER2 will see ?

Keen to know output of *, ALL, & NULL Access in section access

@avinashelite @kushalthakral  @tresesco @prabir_c @eliran @Anil_Babu_Samineni @MayilVahanan @its_anandrjs @MK_QSL @anbu1984 

[BrunPierre]

Firstly, PAT with admin access can see all the information for the REGION value.

In the second case, USER2 has access to all REGION values if "Strict Exclusion" is unchecked or disabled. However, if this is enabled, USER2 won't be allowed access to the document because the table doesn't contain an explicit value that they can access.

Remember that Strict Exclusion is always ON in Qlik Sense.

[piyush_s11]

Hi @BrunPierre 

Thanks for your reply.

I am just expecting what is difference between ALL & * in section access.

Ex: In above scenario consider that there is region in main table & in section access table that region is missing 

then what will be the output if we give * & ALL in this case?

Thanks

@avinashelite @kushalthakral @tresesco @prabir_c @eliran @Anil_Babu_Samineni @MayilVahanan @its_anandrjs @anbu1984 

[MayilVahanan · Accepted solution]

Hi

ALL <-- it will consider all the values from the field

* <-- what are the values included in the section access alone.

For ex, in below sample data, Pat can only see SOUTHEAST ASIA, NORTH ASIA & SOUTH ASIA [not MIDDLE EAST] because, its not mentioned in the section access table. Instead of "*", if we use "ALL", he can able to see all the data.

Hope it will be helpful

SECTION Access;

LOAD * INLINE [

ACCESS, NTNAME, REGION

ADMIN, PAT, *

USER1, CHRIS, SOUTHEAST ASIA

USER2, WILLIAM, NORTH ASIA

USER3, SAM, SOUTH ASIA

];

SECTION Application;

Fact:

LOAD Upper(Region) as REGION, UPPER(Country) AS COUNTRY,* INLINE [

Region, Country, Sales

Southeast Asia, Brunei, 134

Southeast Asia, Cambodia, 93

Southeast Asia, East Timor, 128

Southeast Asia, Indonesia, 9

Southeast Asia, Laos, 10

Southeast Asia, Malaysia, 11

Southeast Asia, Myanmar, 13

Southeast Asia, Philippines, 80

Southeast Asia, Singapore, 3

Southeast Asia, Thailand, 34

Southeast Asia, Vietnam, 182

North Asia, China, 145

North Asia, Hong Kong, 7

North Asia, Japan, 412

North Asia, Macau, 3

North Asia, South Korea, 9

North Asia, Taiwan, 37

South Asia, India, 101

South Asia, Maldives, 3

South Asia, Sri Lanka, 3

Middle East, Bahrain, 8

Middle East, Lebanon, 17

Middle East, United Arab Emirates, 6

];