topic Re: Section access in QlikView

Section access

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Section access

avinashelite — Fri, 19 May 2017 07:45:11 GMT

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

Re: Section access

vardhancse — Fri, 19 May 2017 08:14:27 GMT

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

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
ADMIN, ADMIN, ADMIN123
USER, USER1, USER111
USER, USER2, USER222
];
Section Application;
LOAD * INLINE [
USERID,SHEETNO
ADMIN, 1
USER1, 2
USER2, 3
];

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

Security_Ref:
LOAD * INLINE [
SHEETNO, Dashboard, Analysis, Reports
1, 1, 1, 1
2, 0, 0, 1
3, 0, 1, 0
];

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.