Qlik Community

QlikView Security

Discussion Board for collaboration on QlikView Security.

Not applicable

Qlikview Section Access Restrict Self

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.

AccessUserIDPasswordRegion
AdminAdminAdmin*
User1DorePass1South Asia
User2EmilyPass2Europe

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

5 Replies
sundarakumar
Valued Contributor II

Re: Qlikview Section Access Restrict Self

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

Highlighted

Re: Qlikview Section Access Restrict Self

Try Below

AccessUserIDPasswordREGION
AdminAdminAdmin*
User1DorePass1South Asia
User2EmilyPass2Europe

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

Not applicable

Re: Qlikview Section Access Restrict Self

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.

AccessUserIDPasswordREGIONEMILYROWDOREROW
AdminAdminAdmin***
User1DorePass1South Asia*EXCLDORE
User2EmilyPass2EuropeEXCLEMILY*

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

Thanks, M

Not applicable

Re: Qlikview Section Access Restrict Self

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:

AccessUserIDPasswordACCESS_FLAG
AdminAdminAdmin*
User1DorePass10

Not applicable

Re: Qlikview Section Access Restrict Self

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

Thanks Kristina.

Community Browser