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

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

jim_chan — Wed, 25 Nov 2020 16:16:04 GMT

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 ];

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

trdandamudi — Wed, 21 Aug 2019 12:02:04 GMT

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

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

Brett_Bleess — Tue, 03 Sep 2019 15:53:00 GMT

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