Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May 10, 2021 5:28:08 AM
Dec 30, 2014 11:20:27 PM
For Qlik Sense see Troubleshooting Section Access with Groups in Qlik Sense
QlikView Section Access feature can be used to limit user access to QlikView applications or limit access to the data inside the application.
If the access or data reduction does not work as expected, it is important to validate that the Section Access has been defined in a proper way.
The Section Access table is stored a hidden system table in the QlikView application file. In order to analyse the section access setup, the table must be loaded as a normal table to enable evaluating the content.
Load Section Access (SA) as a normal table
//Section Access;
EXIT Script;
Section Application;
Visualize the Section Access table
IMPORTANT: All fields in the Section Access table must be validated, and not only the example fields above.
Make all fields UPPER case
All data stored in the Section Access table must be in Upper case. This can be accomplished in two different ways.
Avoid NULL values in reduction fields
The reduction field can not contain a undefined value, as then the reduction effect can not be predicted. Null values is a very undefined and abstract value which should never occur in a section access table.
If the reduction is expected to return all values, then the reduction value should be defined as wildcard (*) or a values that does not exist in the data tables reduction field. See Section Access documentation in QlikView Reference Manual for more details on how to include all values.
Avoid NULL values in section access system fields
Null values or empty strings can not exist in the section access fields. In some setups the section access field can be populated with a wildcard (*), but otherwise the fields must always contain real values.
Eliminate duplicate rows
When all data formats are corrected, the last thing to do is eliminate duplicate rows in the section access table. There are two common ways to resolve this.