topic Re: Help with complex section access in QlikView

Help with complex section access

hopkinsc — Tue, 08 Mar 2022 17:39:49 GMT

Hi everyone,

I am struggling to get section access working correctly, I have some complex rules that i need it to use.

Section access is needed to reduce the data based on the following rules
1. User logs in and can see their own data plus data for users that directly reports to him/her.
2. Any user that is within the AREA 'EDU' will need to see ALL data (no reduction).
3. Any user that is within the AREA 'BI' will need to see all data for all users where the Course Name is 'Information Gov*'.

This means that someone in 'BI' will be able to see their own data, anyone that works for them AND ANYONE that has any course name 'Information Gov*' against them.

I have attached a QVW and some data XLSX's, is anyone able to take a look and advise?

I have disabled data reduction in the example attached so it can be opened.

Many thanks in advance

Re: Help with complex section access

hopkinsc — Wed, 09 Mar 2022 08:36:05 GMT

Good morning, does anyone have any ideas on this?

Re: Help with complex section access

Noradavis — Wed, 09 Mar 2022 09:06:29 GMT

Hi all,. I have a complex application with a complex security rules. ... I need a section access to restrict by SCOPE and AREA - Section Access is used to clicker counter control the security of an application. ... Qlik Sense uses this information to reduce data to the appropriate scope when the user opens the application, that is, some of the data in the app is hidden from the user based on their identity.

Re: Help with complex section access

Scott9733 — Thu, 10 Mar 2022 05:47:58 GMT

@hopkinsc wrote:

Hi everyone,

I am struggling to get section access working correctly, I have some complex rules that i need it to use.

Section access is needed to reduce the data based on the following rules AdvancedMD Login
1. User logs in and can see their own data plus data for users that directly reports to him/her.
2. Any user that is within the AREA 'EDU' will need to see ALL data (no reduction).
3. Any user that is within the AREA 'BI' will need to see all data for all users where the Course Name is 'Information Gov*'.

This means that someone in 'BI' will be able to see their own data, anyone that works for them AND ANYONE that has any course name 'Information Gov*' against them.

I have attached a QVW and some data XLSX's, is anyone able to take a look and advise?

I have disabled data reduction in the example attached so it can be opened.

Many thanks in advance

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

Re: Help with complex section access

hopkinsc — Thu, 10 Mar 2022 09:08:26 GMT

Thanks for the replies, I have got it working by concatenating the data back on itself and making the section access link the same as the BI link. So now the BI team can see their own data, their teams data and everyone else that has done a specific course. It has duplicated rows but using a distinct will resolve that.