topic Re: Complex Section Access Solution in QlikView

Complex Section Access Solution

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

I have a requirement : When a User logs in he needs to be given access based on a Business Segment .This is true for all sheets except one. When he moves to say Sheet-Exception he needs to view all data. Is this possible? Are there any alternative solutions?

Re: Complex Section Access Solution

devarasu07 — Fri, 26 Jan 2018 03:29:29 GMT

Hi,

You can try to combine Data reduction with object level then it might work. give a try

also check this section access collection info.

Section Access

in this above link there bypass section access method u can check that option as well. thanks

Thanks

Deva

Re: Complex Section Access Solution

devarasu07 — Fri, 26 Jan 2018 03:59:50 GMT

hi,

refer to the attachment, u can try use "initial selection based on section access" option

download the app try with user

COUNTRY, USERID,PASSWORD,ACCESS
INDIA, DEVA,ADMIN123,USER
SINGAPORE, RAM,ADMIN123,USER
*,ADMIN,ADMIN45,ADMIN

Thanks,Deva

Re: Complex Section Access Solution

avinashelite — Fri, 26 Jan 2018 04:07:57 GMT

Section access will reduce the data based on the login user id , in your case on of the sheet need to show all the data which will be against the section access reduction logic , we could handle this 2 ways

1.for the common data set where you don't want to reduce the data create it as a separate table and add that data to that sheet so full data will be available

2.Make 2 apps . A> with the section access hiding the sheets

B > without section access showing all the data

to navigate from A to B add the button to document chain so that end user does not know he is different app for the common data

Hope this helps you