topic Section Access for Multiple selections and all selections in QlikView

Section Access for Multiple selections and all selections

Tue, 10 Jun 2014 18:27:20 GMT

I am in the process of implementing Section Access on a document that we are releasing shortly. We have tested and have it working for users with only 1 Group (the field we are restricting data by). However, have users that require access to multiple Groups and a few super users that should have access to all Groups. I am using the following code in my script:

SECTION ACCESS;

LOAD

ACCESS,

Upper(USERID) as NTNAME,

Upper(Group) as GROUP

FROM

.\Section Access Setup File.xlsx

(ooxml, embedded labels, table is Sheet1);

And in the file I have the following:

USER	test1	Group1
USER	test2	Group2
USER	test3	Group1,Group2

I know that * is used to denote all options that have been used, but if we don't have a user assigned to every Group I still want my super users to see ALL Groups, so what is the syntax for this, is it 'ALL'?

Does the 'Group1,Group2' syntax work for a user with access to multiple Groups?

Re: Section Access for Multiple selections and all selections

Anonymous — Tue, 10 Jun 2014 18:47:38 GMT

If I use inline load for section access, I use empty value instead of * to give access to all groups, like this:

LOAD * INLINE [

ACCESS, NTNAME, GROUP

ADMIN, SUPERUSER,

];

Maybe it can help you.

Re: Section Access for Multiple selections and all selections

Tue, 10 Jun 2014 18:54:53 GMT

Does that work when you have "strict exclusion" checked in Document Properties?

Re: Section Access for Multiple selections and all selections

ashfaq_haseeb — Tue, 10 Jun 2014 18:58:04 GMT

Hi.

Go through the below posts.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/05/26/section-access

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/09/methods-for-data-reduction

Regards

ASHFAQ

Re: Section Access for Multiple selections and all selections

Anonymous — Tue, 10 Jun 2014 19:19:17 GMT

Yes - but only if user has ADMIN level access, which is typically the case with super-users.

Re: Section Access for Multiple selections and all selections

Tue, 10 Jun 2014 22:01:50 GMT

Good intro's to Section Access but they don't really address the issues that I'm having.

I am going to try Michael's suggestion for the super users, but am still not sure how to accommodate a user having a multiple, yet finite, number of values to reduce their access to.

I believe the 'Group1, Group2' I have above does not work. I am trying to just add a second row for the same user, but with a different value in the GROUP field, like so:

USER

test3

Group1

Group2

Re: Section Access for Multiple selections and all selections

hic — Tue, 10 Jun 2014 22:43:11 GMT

What you need is described in

Generic keys

but to get a general idea, you can read the following also

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

HIC