Implementing Section Access

Save QlikViewEssentials_Presentation.qvw as QlikViewEssentials_Presentation_Secured.qvw. It is important to back up your original file just in case you forget the user ID and password:

1. Open script editor and go to File | Create Hidden Script. Create a password for your hidden script. I used user123.

   

2. Type the following script and load the script:

   Section Access;
   Load * Inline [
   ACCESS, USERID, PASSWORD
   ADMIN, ADMIN, ADMIN
   USER  U1,  U1
   USER  U2,  U2
   USER  U3,  U3
   ];
   Section Application;

   This will create a Section Access script using a Section Access keyword. This script is loading an Inline table with three columns ACCESS, USERID, and PASSWORD. You can use a database table or Excel file to load this info. This script creates four users. One user with Admin-level access and three with User-level access.

3. To test your script, close your application and open it again. It will ask for a user ID and password. Give the user ID and password as mentioned in the previous script...