Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..!!!
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.
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