Chart Level Security

    Hi,

     

    Please find attached Qlikview document for implementing chart level access by user.  You can open the Qlikview file by using users A, B, C and D.  There is no Password for this file.

     

    When you login as user A you can access both charts (CH01 and CH02).

    When you login as user B you can access only one chart (CH01).

    When you login as user C you can access only one chart (CH02).

    When you login as user D you can access both charts (CH01 and CH02).

     

    This is implemented by using Chart Properties -> Layout -> Show -> Conditional.

     

    The charts and users are configured using ChartAccessMatrix table.  Refer below script for implementation.

     

    Section Access;

    LOAD * INLINE [

        ACCESS, USERID

        Admin, A

        User, B

        User, C

        USer, D

    ];

    Section Application;

     

    ChartAccessMatrix:

    LOAD * INLINE [

    USERID, CH01, CH02

    A,1,1

    B,1,0

    C,0,1

    D,1,1];

     

    Regards,

    Jagan.