Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.
Not applicable

Section Access

Hi All, if you can help please let me know...

I want to use section access on a document based on the below criteria but I can't get it working

User 1 can access Region = '1'

but User 2 should be able to access Region = '1' but Country 'France'

How do i achieve this in section access.

Your help would be greatly appreciated

Tags (1)
1 Solution

Accepted Solutions
chauhans85
Esteemed Contributor

Re: Section Access

use below code for example

section access;

Load * inline [

Access,UserID,REGION

Admin,121,

User,122,2

];

SECTION Application;

Load * inline [

REGION,Country

1,France

2,US

];

go to document properties->Opening _> Initial data reduction based on section access

see the attached file

user ID's 121 and 122

hope this helps

3 Replies
Employee
Employee

Re: Section Access

You need to use some way to denote all countries in your authorization table. One way to do this is described on http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

HIC

chauhans85
Esteemed Contributor

Re: Section Access

use below code for example

section access;

Load * inline [

Access,UserID,REGION

Admin,121,

User,122,2

];

SECTION Application;

Load * inline [

REGION,Country

1,France

2,US

];

go to document properties->Opening _> Initial data reduction based on section access

see the attached file

user ID's 121 and 122

hope this helps

Not applicable

Re: Section Access

Works a treat ;-) Thanks

Community Browser