Section Access Management

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.

See: Reduce

Note: Reduction based on Section Access may cause unwanted results in the distributed documents and should be used with caution.

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.

Note: Members of the Administrators group always have access to the section access table.

To manage users and groups, click on this button.

  • Default Scope
  • Select the directory to be searched, in the drop-down list.

  • 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, .

    See: User Management Search Functions

  • Search Result
  • This box presents the result of the search, using the desired criteria.

  • 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.

  • Selected Users
  • This box presents the selected users and groups.

  • < 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.

See: 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, .

    • Default Scope
    • Select the directory to be searched, in the drop-down list.

    • 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, .

      See: User Management Search Functions

    • Search Result
    • This box presents the result of the search, using the desired criteria.

    • 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.

    • Selected Users
    • This box presents the selected users and groups.

    • < 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.

  • 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.
Note: Do 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:
  • Enter the tab separated file contents in this text box.

  • Treat First Row as Column Names
  • 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.

  • Clear Table Data
  • 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.

See: Search Functions

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

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?