topic Re: Limit the access based on selection criteria in QlikView

Limit the access based on selection criteria

danialier — Tue, 04 Nov 2014 16:56:45 GMT

Thanks all for your answers. Unfortunately I still did not succeed on that...

I'm attaching the QV file.

Could someone work on that QV file and make the necessary updates so the section access works ?

Thanks,

Dani

Hello,

I have a QV doc showing revenues per region (AMS / EMEA / APJ). This is a really simple QV with one bar chart showing revenues and one list Box where you can select the region (for which you want to see the revenue).

I'm planning to grant access to lot of people. However I want the folks from AMS to only be able to see AMS revenues, same with EMEA folks with EMEA revenues and same with APJ folks with APJ revenue.

How I can ensure this "privacy" based on user profile ?

thks,dani

Re: Limit the access based on selection criteria

ecolomer — Tue, 04 Nov 2014 21:15:15 GMT

For this one solution is use SECTION ACCESS and assign for each user o group their region and when you open the document select only the data selected by region

Re: Limit the access based on selection criteria

Tue, 04 Nov 2014 21:23:32 GMT

Hola! Dani.

Puedes utilizar el Section Access y este lo puedes hacer en base al campo que desees.

Ejemplo:

Section Access;

LOAD * INLINE [

ACCESS, NTNAME, REDUCTION

Re: Limit the access based on selection criteria

djsampat — Wed, 05 Nov 2014 01:41:23 GMT

Hi Dani,

Use Section Access like below:-

Section Access;

star is *;

LOAD ACCESS,

NTNAME,

USERID,

PASSWORD,

If(REGION='',null(),REGION) as REGION;

LOAD * inline [

ACCESS,NTNAME,USERID,PASSWORD,REGION

ADMIN, *, ADMIN, ADMIN,

USER, *, U1, U1,

USER, *, U2, U2, ALL, ALL, ALL

USER, <DOMAIN/USERNAME>, *, *, *

USER, AMS\DANI, *, *, AMS

USER, APJ\DANI, *, *, APJ

];

star is;

Section Application;

Security:

LOAD DISTINCT REGION,

REGION

RESIDENT ALLREGIONSLIST;

LOAD DISTINCT REGION,

'ALL' as REGION

RESIDENT ALLREGIONSLIST;

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv