Sheet Level Security.qvw

    Today, I am going to share a document on
    applying Sheet Level Security in Qlikview. Suppose our QV Dashboard have 4 levels of users like
    ADMIN  - Who can have access to all sheets
    REGION - Only have access to Sheet1
    COLLECTOR - Only have access to Sheet2
    BROKER - Only have access to Sheet3

    Steps to Implement the Sheet Level Security
    1. Create a new Dashboard and Save the Document.
    2. Go to EDIT SCRIPT
    3. In file Menu open INSERT -> Section Access -> Load Inline
    4. Copy the code below. Make sure all the code is in UPPER case.

    Section Access;
    LOAD * INLINE [
        ACCESS, USERID
        ADMIN, ADMIN
        ADMIN, REGION
        ADMIN, COLLECTOR
        ADMIN, BROKER
    ];

    5. So all have the Admin access but they can able to see only their Respective Sheets. You can combine this Security with Field Level Security for restrict the data.

    6. Now we have to define, To which sheet they have access. The below code mentione that.

    Section Application;

    LOAD * INLINE [
        USERID, SHEET1, SHEET2, SHEET3
        ADMIN, 1, 1, 1
        REGION, 1, 0, 0
        COLLECTOR, 0, 1, 0
        BROKER, 0, 0, 1
    ];

    7. Save the application now. and close the Edit Script window.
    8. Go to Document Properties -> Opening -> Check the boxes Initial Data Reduction & Strict Exlcusion. So that Qlikview restircts the data based on Section access Script.

    I have attached the QVW for the Refrence. One can login using the USERID