QlikView App Dev

[#1]

Dear all,

I'd like to reduce the set of data that individual users have access to with the security fields.

Below is my relatedscript, but seems like it didn't works.

my example document is also attached:

the hidden script password is 123

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, Q

    ADMIN, ADMIN1, 123, *

    USER, USER1, 123, 1

    USER, USER2, 123, 2

    USER, USER3, 123, 3

];

Section Application;

Star is *;

LOAD * INLINE [

    Quarter1, Q

    Q1, 2

    Q2, 3

    Q3, 1

    Q4, 1

];

[tresesco · Accepted solution]

Go to Document Properties -> Opening        and then check 'Initial Data Reduction Based on Section Access'.

Thanks.

[#3]

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, Q

    ADMIN, ADMIN1, 123, *

    USER, USER1, 123, 1

    USER, USER2, 123, 2

    USER, USER3, 123, 3

];

Section Application;

JOIN

LOAD * INLINE [

    Quarter1, Q

    Q1, 2

    Q2, 3

    Q3, 1

    Q4, 1

];

HOPE IT WILL HELP U

[#4]

Wow, didn't notice that

Thanks, dear!

^V^!!