topic Re: Section Access for only one tab in QlikView

Section Access for only one tab

Tue, 02 May 2017 15:38:31 GMT

Hi,

I have a document with 3 tabs, in which one of the tab needs to be restricted and should be available only for a set of users, available in an excel sheet. Additionally, only one group of the users that is available in the excel should get the access (this excel has other purposes for other dashboards).The other 2 tabs should be available to ALL users.

The Excel looks like:

NTNAME	ACCESS	BUDGETACCESS
ABC	USER	Yes
BCD	USER	No

So, here is what i did after loading the excel:

SECTION APPLICATION;

LOAD * INLINE [

BUDGETACCESS,SH07

YES, 1

NO, 0

];

Also, on the restricted tab, i have enabled conditional show with "= sum(SH07)>=1".

I have checked the appropriate checkbox in the Settings/opening.

I have ensured in QMC, the task associated has the section access check box enabled.

With all this, the restriction is not working. Also, for the people who are not in the excel are not able to see the entire dashboard. Ideally, they should be able to see the other 2 tabs.

What am i doing wrong?!

Thanks,

Anitha

Re: Section Access for only one tab

krishnacbe — Tue, 02 May 2017 15:44:05 GMT

Section Application and Section Access script should have below details

1. NTNAME/USERID

2. ACCESS

3. Reduction Fields

in Your Example the table should look like

SECTION APPLICATION;

LOAD * INLINE [

NTNAME, ACCESS, BUDGETACCESS

ABC,USER,YES

BCD,USER,NO

];

Use this Budget Access field to Show/Hide the Sheet.

Re: Section Access for only one tab

Peter_Cammaert — Tue, 02 May 2017 19:19:45 GMT

Section Access restricts access to your document to those users that are explicitly listed in your Section Access table. No one else will get in, UNLESS you add a line with a * in the NTNAME field and a NO in the BUDGETACCESS field.

Note that if you are not using Data reduction, but only data selection in the settings on the Document Properties->Opening tab, you will not protect your document in any way. Anyone who can add a listbox with the BUDGETACCESS field can select the YES value because it will still be available.

The difficulty with Section Access explanations is that they never describe configuration and operation in its entirety. It's way simpler for you to post an example document, and for us to show what we mean.

Re: Section Access for only one tab

Thu, 04 May 2017 11:27:25 GMT

Thanks for your solution. Once I added the line with a * in NTNAME and moved the users who should have access to a different sheet, the solution worked.

Re: Section Access for only one tab

pinky1234 — Mon, 16 Oct 2017 14:02:30 GMT

Hi Anitha,

I am facing the same issue and unable to replicate it.Can you share me Sample Qvw for reference or can you share me the detail script that you have used.

Re: Section Access for only one tab

pinky1234 — Mon, 16 Oct 2017 14:08:04 GMT

Hi Peter,

I am having similar issue.I have two sheets which is Sheet1 and Sheet2. Sheet2 should have access only few people(Not sure how many) but the sheet1 should see everyone.Can you please help me the Sample qvw or detailed script that i can use?.

Thanks in advance!