Qlikview Section Access Restrict Self

[#1]

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

[sundarakumar]

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

[ashfaq_haseeb]

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

[#4]

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

[#5]

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	Admin	Admin	*
User1	Dore	Pass1	0

[#6]

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

Thanks Kristina.