topic Section Access with multiple fields in QlikView

Section Access with multiple fields

amars — Wed, 20 Feb 2013 05:47:07 GMT

Hi all,

We are designing a Section Access for an application, below is the data that we wish to achieve through section access.

USER ID Department Group SubGroup EmployeeType

A Finance * * Manager

A IT * * Developer

B IT Abc xyz Manager

Now after implementating the security we found that the user expecting

User A to see only Manager's in Finance & Developer's in IT

but the Security that I have implementated shows all Developer's & Manager's in IT & Finance (as can be seen after applying the Initial Selection based on section access property ).

All the fields mentioned above are present in the Section Access and in Section Application only line present is * is Star.

I thought to implement a composite key of all the fields but * may occur for all the fields sometime, which prevents me from using a composite key.

Please suggest how this could be achieved.

Thanks in Advance.

Amar

Re: Section Access with multiple fields

hic — Wed, 20 Feb 2013 08:21:44 GMT

You need to use Generic keys. See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

and on

http://community.qlik.com/docs/DOC-3451

HIC

Re: Section Access with multiple fields

IAMDV — Wed, 20 Feb 2013 08:46:05 GMT

Hi Amar,

Please follow what HIC suggested and that should take care of your requirements.

Also, another alternative approach would be implementing Section Access at the most granular level of your data. Which will eventually roll-up based on the Hierarchy.

Also, please be very careful using the '*' (Wildcard) because it doesn't mean all the values in the Actual Field. It means distinct values you have specified in Section Access Table. Unless you have specified all the distinct values within Section Access.

Please read this thread for detailed information and example:

http://community.qlik.com/message/247356#247356

Good luck!

Cheers,

www.QlikShare.com