Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

section access script

hi

i am trying to deploy some security policies using section access. in one of them i want to let each group(active directory group) access data of joust one month, i mean group IT can just see 10th month and 2HR Group to see 11th. but there is a user (m.azizi) whom he is one of members of IT group and he should see both 10th and 11th data.

i have wrote this code but it is not true.

Section Access;

LOAD * INLINE [

    ACCESS, NTNAME

    ADMIN, TAKSARAN\IT

    USER, TAKSARAN\2HR

];

section Application;

LOAD * INLINE [

    NTNAME , d Month

    TAKSARAN\M.AZIZI,10

    TAKSARAN\M.AZIZI,11

    TAKSARAN\IT, 10

    TAKSARAN\2HR , 11

];

1 Reply
Not applicable
Author

Hi,

Here [d Month] SHOULD BE IN Capitals otherwise it won't work.it should be like a [D MONTH]

if your source is like [d Month] just use upper([d Month])

LOAD * INLINE [

    NTNAME , [D MONTH]

    TAKSARAN\M.AZIZI,10

    TAKSARAN\M.AZIZI,11

    TAKSARAN\IT, 10

    TAKSARAN\2HR , 11

];