Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Access on Region

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:

ACCESSUSERIDPASSWORDREGION
ADMINADMINADMIN
USERUSERUSER
USERAANA
USERBBEMEA
USERCC*

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

3 Replies

Re: Access on Region

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


talk is cheap, supply exceeds demand
payalgosar
Contributor II

Re: Access on Region

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")

payalgosar
Contributor II

Re: Access on Region

Hi,

You can refer to Section Access for more information.

Community Browser