showorhide

Have you been asked to hide a sheet or sheet object to implement Qlikiew security using AD groups? You’re not alone!

In this QlikView tutorial, we will walk through a step by step process to hide or show sheets and sheet objects using AD groups.

Ingredients:

We will use document triggers, variables and conditional show features in this QlikView tutorial.

Step 1: Load Account Name and AD groups first.

ad groups

step 2: Now, let’s add ‘OnOpen’ document event triggers
triggers
Now, let’s add some actions as soon as user opens document.

qlikview triggers

Now, let’s create two variables, vExec and vManagers, and set their values.

qlikview variables

 

 

 

 

 

 

 

 

qlikview variables 2

 

 

 

step 3: Now, let’s use variable in the conditional show to hide a sheet with sensitive data from managers.

 

conditional sheet show

 

That’s it. By using variable, you can not only hide sheets but also sheet objects by using conditional show in the layout tab of each object. Also, use of variable allows you to create multiple conditions thus you can show or hide sheets or sheet objects for a user who belongs to certain group or groups.

Elsewhere:

1. No body said it was easy… configuring LDAP via Qliktips

2.  QlikView conditional enablement of expressions via QlikShare

3. Using Column visibility via QlikViewCookbook