2 July 2026

Table Recipe: Calculated column and Format number functions

Share this message

Table Recipe adds calculated columns and number formatting, bringing more flexible data preparation logic into the no-code, spreadsheet-like interface.

  • Calculated column: Add a new column based on a Qlik script expression combining existing columns and functions. This lets you build more complex logic in a single recipe step, covering use cases that previously required scripting, with a built-in expression editor providing syntax highlighting, autocomplete, inline function guidance, and direct links to Qlik Help.

    Columns functions

  • Format number: Change how numeric values are displayed using predefined or custom patterns, with configurable decimal and thousand separators. The Format number function is also added to the Numbers processor in Data Flow.

    Numbers functions

  • When configuring a filter, a “Show more” button lets you load more value suggestions from the selected column.

How can we help?

Whether something’s still unclear or you’re ready to take the next step, Barry and Eric are happy to talk it through. Email us, call us, or book a meeting at a time that works for you.