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.
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