On the Section Access Management page, all the available tables for section access are listed in a tree view in the left pane. These tables act as a central repository for section access tables to use in QlikView documents. The actual use of these tables is defined in the load script of the document.
Section access is similar to reduction, but is done by the QlikView Server when a user accesses the document. The choice between section access and static reduction is a question of performance and memory usage. When QlikView Publisher opens a section access protected QlikView file, the file is reduced based on the reduction values.
Section Access Tables
Section Access Table URL
In order to use all of the defined section access tables, add the presented path (URL) to the load script in the QlikView Script Editor.
Add
To create a table entry, click on the Add icon, 
, to the right in the pane, and enter a descriptive name in the new text box. The new table will be available in the tree view in the left pane.
Delete
To entirely remove a configured entry from the list, click on the Delete icon,
.
Manage Section Access Tables
To view and manage the settings of an existing section access table, in the right pane, click on the table in the tree view in the left pane. For example, click on the predefined table named default.
Allowed Users...
The current section access table URL can be configured, so that only specific users can use it.
To manage users and groups, click on this button.
- Search for Users and Groups
Enter the desired search term(s) in this text box, to find a user or a group, and click on the Search icon,
. - Default Scope
Select the directory to be searched, in the drop-down list.
- Search Result
This box presents the result of the search, using the desired criteria.
- Selected Users
This box presents the selected users and groups.
- Add >
To add a user or a group, click on it in the Search Result box and click on this button. Several items can be added at the same time.
- < Delete
To deselect a user or a group, click on it in the Selected Users box and click on this button. Several items can be deselected at the same time.
- << Delete All
To deselect all of the users and groups from the Selected Users box, click on this button.
Search for Users in
In the drop-down list, select the directory service connector, in which to search for users and groups using the Allowed Users... function. This also applies to the section access tables below (Column User with the clickable icon that brings up Manage Users).
Edit Columns...
In the Edit Table Columns dialog columns can be added to, or removed from, the current section access table. The available table columns are listed in Table Columns.
To open the dialog, click on this button.
- QlikView Column
This list contains all the possible reserved columns in a QlikView section access table. To view an explanation of a column, click on it. The explanation is presented between the left available columns list and the right chosen columns list.
- Add Column (upper)
To add a reserved column to the current section access table, click on the column and click on this button. The column is moved from the left available columns list to the right chosen columns list.
- Type Column
To add a custom column to the current section access table, enter a name in this text box and click on the Add Column (lower) button.
- Add Column (lower)
To add the custom column to the current section access table, click on this button. The new column is added to the right chosen columns list.
- Promote
To move a column to the left, within the current section access table, click on the column in the right chosen columns list and click on the Promote icon,
, as many times as needed. The column will be moved upwards in the right chosen columns list and to the left in the current section access table. - Demote
To move a column to the right, within the current section access table, click on the column in the right chosen columns list and click on the Demote icon,
, as many times as needed. The column will be moved downwards in the right chosen columns list and to the right in the current section access table. - Remove Column
To entirely remove a column from the current section access table, click on the column and click on this button. Reserved columns are moved from the right chosen columns list to the left available columns list, whilst custom columns are deleted.
Table Columns
The following table columns are available:
- ACCESS, a field that defines what access the corresponding user should have. The following options are available in the drop-down list:
- ADMIN
- USER
- NTNAME, a field that should contain a string corresponding to a Windows NT domain user name or group name. In this filed, users and groups are given access to the documents distributed by the section access functionality. The QlikView Server will fetch the logon information from the operative system and compare it to the value in this field. To manage users and groups, either enter a valid string in this field, or do the following:
To manage users and groups, click on the Manage Users dialog icon,
.- Search for Users and Groups
Enter the desired search term(s) in this text box, to find a user or a group, and click on the Search icon,
. - Default Scope
Select the directory to be searched, in the drop-down list.
- Search Result
This box presents the result of the search, using the desired criteria.
- Selected Users
This box presents the selected users and groups.
- Add >
To add a user or a group, click on it in the Search Result box and click on this button. Several items can be added at the same time.
- < Delete
To deselect a user or a group, click on it in the Selected Users box and click on this button. Several items can be deselected at the same time.
- << Delete All
To deselect all of the users and groups from the Selected Users box, click on this button.
- Search for Users and Groups
- NTSID, a field that should contain a Windows NT SID. The QlikView Server will fetch the logon information from the operative system and compare it to the value in this field.
Example:
S-1-5-21-125976590-467238106-1092489882-1378
- NTDOMAINSID, a field that should contain a string corresponding to a Windows NT Domain SID.
- SERIAL, a field that should contain a number corresponding to the QlikView serial number. The QlikView Server will check the serial number of the user and compare it to the value in this field.
Example:
4900 2394 7113 7304
- USERID, a field that should contain an accepted user ID. The QlikView Server will prompt for a user ID and compare it to the value in this field. This user ID is not the same as the Windows user ID.
- PASSWORD, a field that should contain an accepted password. The QlikView Server will prompt for a password and compare it to the value in this field. This password is not the same as the Windows password.
- OMIT, a field that should contain the field that should be omitted for this specific user. Wildcards may be used and the field may be empty. A facile way of doing this is to use a sub field.
Information noteDo not apply OMIT on key fields, since this changes the underlying data structure and may create logical islands and calculation inconsistencies.
- Custom, a custom field defined as desired.
Import Table Data...
The contents of a tab separated file can be pasted into the current section access table. To open the Import dialog, click on this button.
- Paste Tab Separated File Below:
- Treat First Row as Column Names
- Clear Table Data
Enter the tab separated file contents in this text box.
If the first row of the tab separated file is made up of, for example, column names, this row should not be imported. To exclude the first row from being imported, tick this check box. To include the first row to being imported, untick this check box.
If the imported data is to replace the possibly already existing data in the current section access table, tick this check box. If the imported data is to be appended into the current section access table, untick this check box.
Search
To filter the list of entries for the current section access table, enter the desired term(s) to search for in all columns in this text field, and click on the Search icon, , to initiate the search and filtering.
Add
To create a table row entry in the current table, click on the Add icon, , to the left in the table header. The new entry will be added last in the table.
Copy and Paste
To copy a table row entry in the current table, click on the Add Row icon, 
, in the table row to be copied. The new entry will be added just under the copied entry in the table.
Delete
To entirely remove a configured entry from the list, click on the Delete icon,.
Number of Entries
Presents the number of configured entries in the current section access table. Select the number of entries to be presented on each page, in the drop-down list:
- 10 per page
- 20 per page
- 50 per page
- 100 per page
