topic Manage Section Access via Excel in QlikView

Manage Section Access via Excel

2bxornot2b — Tue, 31 Dec 2019 09:26:05 GMT

Hello everyone,

I have a few questions regarding section access via an Excel table.
I have a manifold of users, some of them are allowed to see all data, but most of them are only allowed to see data that meets one of three criteria that are defined in the original table.

So for example:
There is an original file that contains sales data with different products, countries, User A is allowed to see all data where Country = France, Product = Paper or sales person = User A.

As there are so many different users with different entitlements, I'd like to put them in an Excel file instead of the code, but I'm not sure how to include the "or" condition here.

Also, I experienced some difficulties choosing only one criterion, as it forbade any test users without admin rights to access the document. All headlines in the original file are written in upper cases.

Any ideas?

Re: Manage Section Access via Excel

salted — Tue, 31 Dec 2019 09:52:03 GMT

Try creating a generic key with all option added like

country|Product|SalesPerson etc

and create one in the backend data source

https://community.qlik.com/t5/QlikView-Documents/Generic-keys/ta-p/1496560

Re: Manage Section Access via Excel

Kushal_Chawda — Tue, 31 Dec 2019 10:14:17 GMT

see this

https://community.qlik.com/t5/Qlik-Design-Blog/Basics-for-complex-authorization/ba-p/1465872

https://community.qlik.com/t5/QlikView-Documents/Complex-Authorization-How-to-create-authorization-bridge/ta-p/1483860

Re: Manage Section Access via Excel

Brett_Bleess — Tue, 31 Dec 2019 13:26:06 GMT

Kush's reply is spot on, the first link should be what you need to review, and I just wanted to point out the other links at the bottom of that post, may be good to review those too just to get the complete picture on everything, but that should cover what you need. If that works, be sure to use the Accept as Solution button on Kush's post to give him credit for the help and let other Community Members know that worked for you. If you have further questions, shout back.

Regards,
Brett