topic Access on Region in QlikView

Access on Region

Thu, 01 Dec 2016 19:51:38 GMT

Hi all,

I'm stuck on giving specific people access to certain regions in the dashboard.

Section Application;

LOAD REGION,

Fee

FROM

[Advanced User Access Testing.xlsx]

(ooxml, embedded labels, table is Sheet1);

SECTION Access;

LOAD ACCESS,

USERID,

PASSWORD,

REGION

FROM

[Advanced User Access Testing.xlsx]

(ooxml, embedded labels, table is Sheet2);

my Regions are: NA, EMEA, LATAM, ASIA and the fees are just a made up # for now.

My access are:

ACCESS	USERID	PASSWORD	REGION
ADMIN	ADMIN	ADMIN
USER	USER	USER
USER	A	A	NA
USER	B	B	EMEA
USER	C	C	*

But when I log in as user B i can see everything still

Re: Access on Region

Gysbert_Wassenaar — Fri, 02 Dec 2016 08:41:14 GMT

Did you enable the options Initial Data Reduction Based on Section Access and Strict Exclusion on the Opening tab of the Document Properties window?

Re: Access on Region

Anonymous — Fri, 02 Dec 2016 08:56:36 GMT

Hi,

Try below mentioned script.

PFA attached qvw for the same.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, REGION

ADMIN, ADMIN, ADMIN, *

USER, A, A, EMEA

USER, C, C, LATAM

USER, E, E, NA

USER, DUMMY1, DUMMY1, ASIA

];

Section Application;

Table:

LOAD * INLINE [

REGION, NAME

EMEA, A

EMEA, B

LATAM, C

LATAM, D

NA, E

NA, F

ASIA, G

ASIA, H

EMEA, I

];

Note: Enable property in settings (Settings-> Document Properties -> Opening -> "Initial Data Reduction Based on Section Access")

Re: Access on Region

Anonymous — Fri, 02 Dec 2016 09:00:07 GMT

Hi,

You can refer to Section Access for more information.