Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alec1982
Valued Contributor II

Section Access

Hi Guys,

I have one table qvw that I have set section access on.

The section access has three fields:

Manager

Director

Region

For user A I am trying to let him see data for two regions one where he is a manager(So he will see data if he is listed as manager)

and the second region where he can see everybody

On the section access table I did the following:

ACCESS     NTNAME     MANAGER     DIRECTOR     REGION    

ADMIN          ADMIN    

USER               A                    A                                REGION1

USER               A                                                      REGION2

According to this scenario user A should see data for REGION1 where he is manager and all data for REGION2 but this is not working. he only sees data where he is manager in both regions..

Any idea on how can I fix this.

Best,

Alec

1 Solution

Accepted Solutions
alec1982
Valued Contributor II

Re: Section Access

This has been fixed using the following post:

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

Best,

Alec

10 Replies
alec1982
Valued Contributor II

Re: Section Access

Looks like no answer. hope someone can help!

MVP
MVP

Re: Section Access

Have a look here

alec1982
Valued Contributor II

Re: Section Access

Hi,

Thank you for your reply! this is helpful to understand section access but in my case it doesn't help. I am not using *  as you can see above.

Best,

Alec

MVP
MVP

Re: Section Access

Hi,

The blank in Manager/Director will work only if the access for the user is ADMIN and the document is being opened locally (Desktop, not on server, plugin, ajax, etc), because when you open the document on server, all users are given USER access, regardless what they have in section access.

The use of "*" will only work if the field Region has all possible values you want to see, in your example above.

Hope this helps.

alec1982
Valued Contributor II

Re: Section Access

Hi,

Thxs for your help.

I tried to put * in the empty fields above and all values in REGION are listed above(REGION1, REGION2)

but the issue still exist..

Best,

Alec

MVP
MVP

Re: Section Access

Can you please share the app with sample data? let know the admin id and pwd as well.

alec1982
Valued Contributor II

Re: Section Access

I wish I could but I am not allowed to do that.. and the qvw is huge.

the section access looks like the above and in the data user A is a manager in region1 and he is NOT a manager or director in region2..

I want user A to see his data from region1 and all data in region2 for all manager and directors

hope that explain it..

best,

alec

MVP
MVP

Re: Section Access

I am sure that you have not made that silly mistake, still asking to be sure, you are using ACCESS (and not SECTION) as your first section access heading.

alec1982
Valued Contributor II

Re: Section Access

Oh! this mistake is only here on the discussion.and not on the actual qvw.

Best,

Alec

Community Browser