Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content Skip to complementary content

Window processor

Performs calculations on specific data ranges.

The Window processor allows you to aggregate and perform calculations using values from multiple rows grouped in a range, and produce a value for each row separately.

Usage

The Window processor requires one input flow and can generate only one output flow.

Properties

Properties configure in order to configure windows aggregations.

Operation
Property Configuration
Operation
  • Sum: Caculates the sum of the records in the selected range.

  • Avg: Calculate the average value of the records in the selected range.

  • Min: Returns the smallest value of the selected range.

  • Max: Returns the largest value of the selected range.

  • Count: Retrieves the number of records in the selected range

  • First: Retrieves the value of the first record of the selected range.

  • Last: Retrieves the value of the last record of the selected range.

  • Row number: Assigns a row number to each value of the selected window.

  • Rank: Calculates the rank of the selected range compared to the other windows.

Fields

Select the field or fields on which you want to apply the function.

Tip noteIf you want to apply the same function to multiple fields at once, click the Open dialog. Open dialog icon to open a tree view that allows you to select multiple fields.
Output field name Give a custom name to the output field.
Partition by
Property Configuration
Fields

Select the field or fields by which to partition.

Tip noteIf you want to select multiple fields at once, click the Open dialog. Open dialog icon to open a tree view that allows you to select multiple fields.
Sorting
Property Configuration
Sort by

Select a field from the incoming data to sort by.

Sort order
  • Ascending

  • Descending

Range
Property Configuration
Start
  • Unlimited

  • Current row

  • Preceding

  • Following

End
  • Unlimited

  • Current row

  • Preceding

  • Following

Number of rows (optional)

If you select Preceding or Following, enter a number of rows to set the range of action of the function.

To rename the processor or edit its description, click the Edit Edit icon next to the processor name in the Properties panel.

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!