topic Re: Section Access Problem in QlikView

Section Access Problem

Mon, 26 Jan 2026 18:19:17 GMT

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..!!!

Re: Section Access Problem

jagan — Tue, 24 Dec 2013 05:16:16 GMT

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.

Re: Section Access Problem

Tue, 24 Dec 2013 05:18:34 GMT

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