Reduce

On the Reduce tab, a document can be configured how to be split into several reduced copies of the original.

A reduced document contains only the reduced information, while a document using the section access function contains all information, but hides and reveals parts of it.

Section Access Management

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

Reduction Method

Select one of the following options:

  • Reduce by Field Value, meaning that one reduced document is created, by selecting the fields and values that should be distributed.
  • Simple Reduce

  • Reduce by Bookmark, meaning that one reduced document is created, by selecting the bookmarks that should be distributed.
  • Reduce by Bookmark

You can also create several separate documents, based on a field value or on a bookmark.

Loop and Reduce

Open Document

To be able to use the contents of the document for selecting bookmarks or fields and field values, the document has to be opened by clicking on this button.

Hinweis: Using this function, that is, clicking the Open Document button or the ... button (if available), might be time consuming; therefore, it is done as an explicit command.

Reduced Document Name

Save the Reduced Document with the Following Name

The name template for the reduced user document.

User Documents

To create a document name template, either open the advanced name template dialog by clicking on the Edit NameTemplate icon, , and perform the configuration, or edit the default document name template in this text field.

Hinweis: Be sure to create unique resulting document names, to avoid documents to be overwritten.

The advanced name template dialog contains the following fields:

  • Publisher Elements
    • Source Document Name
    • Task Name
    • Serial Number
    • Script Variable Value
    • Select Document Field
    • '\' (back-slash), '-' (dash), '_' (under-score), ' ' (white space)
  • Date and Time
    • Year - Two Digits
    • Year - Four Digits
    • Month
    • Month Text
    • Day
    • Year Month Day
    • Hour (AM/PM)
    • Hour (24h)
    • Hour Minute
    • Year Month Day - Hour Minute

To create a document name template, click on the buttons to insert values from the Publisher Element and Date and Time panes. The resulting template is presented in the Template field, which can also be freely edited. In the Example field, the resulting document name is presented, using the applicable current values.

Simple Reduce

Presents the Fields and Values that are available in the document.

Hinweis: Only the first 1000 entries are included. All data not selected from the boxes will be removed from the reduced document.
Hinweis: This option is only available if the Reduce by Field Value option was chosen.

Fields

To select the fields that should be part of the reduced document to be distributed, select them in this box.

Values

To select the values that should be part of the reduced document to be distributed, select them in this box.

Selected Fields

Presents the selected fields.

Selected Values

Presents the selected values.

Clear Selection

To clear all selected fields and values, click on the Clear Selection icon, .

Reduce by Bookmark

Presents the Bookmarks that are available in the document. To select the bookmark to distribute, scroll down the drop-down list and select it.

Hinweis: All data not selected from the drop-down list will be removed from the reduced document.
Hinweis: This option is only available if the Reduce by Bookmark option was chosen.

Loop and Reduce

Hinweis: QlikView does not support Loop and Reduce over tables that contain input fields. The original value of each input field is replaced by the index value of the row in the table.

By Field Value

To create several separate documents for each value in the selected field, choose this option, then select the Field from which the value is to be looped.

By Bookmark

To create one separate document per each available bookmark, choose this option.