Implementation of Security In QlikView Application

Introduction

This article provides a basic procedure for implementing security in QlikView.

Step 1:
First we need to open the QlikView application, then go to:

"File" -> "New"

Then the window look like this:

After clicking New option

Step 2: Then we need to upload an Excel file by simplly clicking a Browse button.

After Clicking New button

We upload a file, from where we saved our file.

Upload a file

Step 3: After opening our Excel file, then this window will be opened; then click on the "Next" button.

opening our excel file

Step 4: After click on the "Next" button, we need to verify our data and then click on the "Next" button.

verify our data

Step 5: The next step is to save our QlikView file with the extension ".qvw", anywhere you want and simply click on the "Save" button.

Save our QlikView file

Step 6: Then we need to simply click on the "Next" button.

Click on next button

Step 7: The next step is to select the chart type, and click on "Next" button.

Select the chart type

Step 8: The next step is to select the dimension and list boxes, this window will be opened.

Select the dimension


Step 9:
Then, we need to add an expression and click on the "Finish" button.

Add expression 
 
 Step 10: This is the final window, in this window we can see the representation of the data.
 

Final window


Step 11: Now we need to open the Edit Script using "File" -> "Edit Script"; the following window will then be opened.
 
Window of edit script


Step 12:
The next step is write the code for the edit script.

Write code in Edit Script

 
 
Step 13: Now, we need to select the system variable.
 
Select the system variable


Step 14: Now we go to "Insert" -> "Section Access" -> "Inline", then this window will be opened:

Open the inline window


Step 15: Then this window will be opened and then click on the "OK" button.

Open the access restriction window

Step 16: Then we need to create the inline data wizard and click on the "OK" button to finish this process.

Create the unline data

 This is the final window.

last window

 Summary

This article described the basic procedure to implement security in a QlikView application because security is very important for the organization.