Section access

[#1]

Post translated using Google Translate.

Please only post in English unless you are posting in a language specific section.

---

Good I'm new here and do not really know how this works, but would need some advice from you.

My doubt is:

Having several users created in qlikview (10 users) as I can would limit or block some users so they can not see some of the leaves that I have created in qlikview, I tested with section access but I can not do it, if someone tells me as to do otherwise .....

Thanks in advance.

[avinashelite]

could you explain your requirement ? so that we could suggest the solution

[vardhancse]

Hi,

What I understood was you are trying to implement sheet level security to your dashboard?

If yes, Here is the step by step process;

1. Open the application and go to the Edit Script section

2. Select Create Hidden Script option from File Menu

3. Set Password for the same

4. Paste below given sample script

1. Section Access; 
2. LOAD * INLINE [ 
3.     ACCESS, USERID, PASSWORD 
4.     ADMIN, ADMIN, ADMIN123 
5.     USER, USER1, USER111 
6.     USER, USER2, USER222 
7. ]; 
8. Section Application; 
9. LOAD * INLINE [ 
10. USERID,SHEETNO 
11. ADMIN, 1 
12. USER1, 2 
13. USER2, 3 
14. ]; 

5. Place the cursor at the bottom of Main tab and paste below given sample script

1. Security_Ref: 
2. LOAD * INLINE [ 
3. SHEETNO, Dashboard, Analysis, Reports 
4. 1, 1, 1, 1 
5. 2, 0, 0, 1 
6. 3, 0, 1, 0 
7. ]; 

6. Now save the changes and hit Reload button

7. Change the Show Sheet - Conditional settings for every sheet as -

//Dashboard Sheet

=Dashboard

//Analysis Sheet

=Analysis

//Reports Sheet

=Reports

8. Once this is done then open the document properties (Ctrl + Alt + D) and tick below options present on Opening tab.

Initial Data Reduction Based On Section Access

Strict Exclusion

9. Save the application and close.

Now, while opening the document application will ask for credentials. Enter the respective credentials to get the desired results.