How To Set Up Section Access to reduce access for specific sheets in Document
I wanted to know how to setup section access in QlikView so that the user has access to certain tabs as specified in the section access script.
For example I have a QlikView document which has a high-level executive dashboard on one tab and four other tabs with further analysis of the high-level dashboard. I want executives with a username and password to only have access to a tab in the document which points to the executive dashboard and the team who do the analysis to have access to the tabs which hold the further analysis. I do not want the analysis team to have access to the executive dashboard and I do not want the executive to have access to the analysis tabs in the document.
I have already done section access reducing data based on fields by specifying the fields in the section access script and this works.
Just like data reduction, is there a way to do this to reduce tabs in QlikView?
Re: How To Set Up Section Access to reduce access for specific sheets in Document
Hi QV Learner
Thank you for the reply. This is quite useful.
I tried to apply it to my example but the sheet access did not work. The data field reduction is working but the tab access reduction is not.
Here is my code taken directly from my script.
(ooxml, embedded labels, table is Sheet1);
(ooxml, embedded labels, table is Sheet2);
upper(Company) AS COMPANY ,
UPPER(Platform) AS PLATFORM
(ooxml, embedded labels, table is Platforms);
As you can see I have two section application tables. One is to load the tab access spreadsheet taken from your example and the other one is for linking the field 'COMPANY' so that the data reduction can happen.
The data reduction is fine and the usernames and corresponding passwords are working too. It's just the sheet access not working.