topic Re: Qlikview Section Access Restrict Self in QlikView

Qlikview Section Access Restrict Self

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I have a requirement wherein the user can see data as specified but, should not be able to see his own record. For example, let's take an user "Emily". She will have access to region "Europe" but, since, she is in "Europe". She cannot have access to her own data.

Access	UserID	Password	Region
Admin	Admin	Admin	*
User1	Dore	Pass1	South Asia
User2	Emily	Pass2	Europe

In the above table, 'Dore' & 'Emily' should be provided with access as specified but, not self. How do I achieve this through Section Access? Or is there any other way?

Thanks for your help.

Regards, M

Re: Qlikview Section Access Restrict Self

sundarakumar — Sun, 22 Jun 2014 05:03:58 GMT

The users name should be in some field, as u have specified it as the user's data. say the user is the sales person, then u have the field sales person.u can bring in this field too in section access and show them only the others data right.

Correct me if am wrong. or pls explain the scenario.

Regards,

Sundar

Re: Qlikview Section Access Restrict Self

ashfaq_haseeb — Sun, 22 Jun 2014 05:06:21 GMT

Try Below

Access	UserID	Password	REGION
Admin	Admin	Admin	*
User1	Dore	Pass1	South Asia
User2	Emily	Pass2	Europe

Make sure in document properties -->op open tab--> Initial data reduction based on section access, Initial selection based on section access are selected.

Regards

ASHFAQ

Re: Qlikview Section Access Restrict Self

Sun, 22 Jun 2014 06:24:26 GMT

Hi - Thanks for the quick reply.

Let me clarify a little more on this. I work in HR Analytics and creating a tool that will help assess the performance across the organisation. In the example, they are heads of the region. They can see all the data except their own.

THEY SHOULD NOT SEE THEIR OWN DATA. In other words, I want the access to be taken away for the own record.

I could create a separate fields but, this would mean one field per record like the below.

Access	UserID	Password	REGION	EMILYROW	DOREROW
Admin	Admin	Admin	*	*	*
User1	Dore	Pass1	South Asia	*	EXCLDORE
User2	Emily	Pass2	Europe	EXCLEMILY	*

I have more than 50 users so, dont this will be effective solution. Please help.

Thanks, M

Re: Qlikview Section Access Restrict Self

Tue, 24 Jun 2014 11:08:44 GMT

Hi M,

u can create a special field in your table in the section application, which will show you whether it's user's region or not, by applying a condition like

if (REGION=USERS_OWN_REGION, 1, 0) as ACCESS_FLAG.

Then in section access write:

Access

UserID

Password

ACCESS_FLAG

Admin

User1

Dore

Pass1

Re: Qlikview Section Access Restrict Self

Tue, 24 Jun 2014 11:34:21 GMT

Wow.... that's innovative. Yes. I think this should do the trick. I will try it.

Thanks Kristina.