topic Re: data reduction based on session access in QlikView

data reduction based on session access

Mon, 01 Jul 2013 05:49:08 GMT

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

];

Re: data reduction based on session access

tresB — Mon, 01 Jul 2013 06:04:21 GMT

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

Thanks.

Re: data reduction based on session access

Mon, 01 Jul 2013 06:05:26 GMT

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

Re: data reduction based on session access

Mon, 01 Jul 2013 06:07:15 GMT

Wow, didn't notice that

Thanks, dear!

^V^!!