Section Access, how to list all value using '*' ?

[jim_chan]

Hi there, 

I am creating a section access & section application. I use section application to control the sheet. 

Exmaple:

1) Region A - can see sheet 1 ,2,3, Region B and see 3, 4, 5

2)PowerUser1 can see all the regions(A,B), meaning can see all the sheets.

so i have something like this under section application.BUT, it is not working. as PowerUSer1, when i change my region to '*', i cant see all the sheets, nothing. When i change my region  to region A or B, is fine. can see the sheets respectively.

Section Application;

REGION:
LOAD * INLINE [

REGION, SH01,SH02,SH03,SH04,SH05

A, 1,1,1,0,0,0

B, 0, 0, 1,1,1

*, 1,1,1,1,1   ];

[trdandamudi]

I think the below link should get you on the right track:

https://community.qlik.com/t5/QlikView-Documents/Sheets-Security-with-Section-Access/ta-p/1476875

[Brett_Bleess]

Adding a Design Blog post for you as well, there are multiple links in that post too, so further information for you other than just the single post, hopefully that will do the trick for you if the other post did not.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

Regards,
Brett