topic Re: Section Access in QlikView

Section Access

Tue, 15 Sep 2015 04:21:32 GMT

I want to implement NTNAME based section access but only for few users and I want other users to see all the data even if they are not included in the section access

For ex : I have one AD group (e.g. myteamadgroup) where 10 team mates are member of this group. In my data model there is one REGION field which has data like REGION1,REGION2,REGION3,REGION4

I want to design section access only for 4 members with restriction on REGION field (e.g. when they log in to dashboard then they should see only REGION1's data) and rest of members should login to the dashboard and should see all the data (Even if they are not part of section access) Is this possible?

Re: Section Access

Anonymous — Wed, 21 Oct 2015 19:01:48 GMT

Hi Rahul,

Created on excel file and include 2 tabs within that excel. Follow the attached way to accomplish the section access you want. Don't forgot to update the setting Initial data reduction option in document properties >.Opening tab.

tab - 1

ACCESS	NTID	LEVEL
USER	You ID	All
ADMIN	You ID	ADMIN
USER	User NT ID	Group A
USER	User NT ID	Group B
USER	User NT ID	Group C
USER	User NT ID	Group D
USER	User NT ID	All
USER	User NT ID	All
USER	User NT ID All

Tab - 2

REGION	LEVEL
EAST	Group A
WEST	Group B
SOUTH	Group C
NORTH	Group D
EAST	All
WEST	All
SOUTH	All
NORTH	All

Regards,

Imran K

Re: Section Access

srchilukoori — Wed, 21 Oct 2015 19:46:49 GMT

Hi Rahul,

Include the following record in your section access table

NTNAME, ACCESS, <REDUCTION FIELD>

*, USER, *

This gives unrestricted access to data for all users not listed in the AD group.