Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

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 Problem


Hello,

I have a ierarchy of data,like:

Naion->region-> Territory.

Now i want to give section access like if person from territory1 will log in then he should be able to see his own territory data as well as the region and nation level overview data.

How such access should be given??

thanks in advance..!!!

2 Replies
MVP
MVP

Re: Section Access Problem

HI,

Try this

How to Distribute Dashboard and Implement Section Access

From Qlikview Help file:

Example:

section access;

load * inline [

ACCESS, USERID,REDUCTION, OMIT

ADMIN, ADMIN,*,

USER, A,1

USER, B, 2,NUM

USER, C, 3, ALPHA

];

section application;

T1:

load *,

NUM AS REDUCTION;

load

Chr( RecNo()+ord(‘A’)-1) AS ALPHA,

RechNo() AS NUM

AUTOGENERATE 3;

The field REDUCTION (upper case) now exists in both section access and section application (all field values are also upper case). The two fields would normally be totally different and separated, but if the Initial Data Reduction Based on Section Access option has been selected, they will link and reduce the number of records displayed to the user.

The field OMIT in section access defines the fields that should be hidden from the user.

The result will be as follows:

User A can see all fields, but only those records connected to REDUCTION=1.

User B can see all fields except NUM, and only those records connected to REDUCTION=2.

User C can see all fields except ALPHA, and only those records connected to REDUCTION=3.

Regards,

Jagan.

Not applicable

Re: Section Access Problem

Priya,

Implement section access in territory level.

The user who is having access to the territorry1 will see the region and national level data which belongs to territory1.

Thanks,

sampath

Community Browser