Section Access - Reduction field showing all values
We use the reduction field [RANGE] to not only reduce the data shown in a report, but also to show/hide a number of the sheets. Here is the section access code.
Security: LOAD[ACCESS], NTNAME, RANGE FROM ..\..\Security\Spreadsheet.xlsx (ooxml, embeddedlabels, tableis ACCESS);
LOADRANGE, Transaction FROM [..\..\Security\FinanceAccessControl.xlsx] (ooxml, embeddedlabels, tableis RANGE);
The values for [RANGE] are either 'ALL', 'AP', 'AR' and a [NTNAME] is only assigned one of these values. *NOTE for the service accounts the [RANGE] value is blank.
The formula for show/hide of the sheets is based on the following (with variations according to who should see the sheet)
Intermittently, in both the desktop application and in AccessPoint, all the show/hide sheets are hidden, and a debug tab shows that the [RANGE] field contains all three of the available values, which makes the Only() functions in the show/hide formula return NULL.
Reopening the .qvw in the desktop application solves the problem, and restarting the QVS service solves the problem in AccessPoint.
Has anyone seen this before? And more importantly, do you know what causes it and how it can be resolved?
Re: Section Access - Reduction field showing all values
There you have it. If a user enters a document with section access and strict exclusion disabled and data reduction reducing away all data (because of no linkage, wrong link values or simply no relevant data) then he or she will get access to everything. That's standard QlikView behavior.
Enable "Strict Exclusion" if you want the door closed for people that shouldn't get any access. They won't see a thing anyway...