Skip to main content Skip to complementary content

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.

Reduce

Information noteReduction 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, Add, 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,Delete.

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.

Information noteMembers of the Administrators group always have access to the section access table.

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

    User Management Search Functions

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

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, Arrow Up, 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, Arrow Down, 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, Manage users.

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

      User Management Search Functions

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

  • 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:
  • 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, Search, to initiate the search and filtering.

Search Functions

Add

To create a table row entry in the current table, click on the Add icon, Add, 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, Add row, 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,Delete.

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 page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com