Skip to main content Skip to complementary content

Variables do not expand before calculating

Possible cause  

Your variables may be missing an = sign at the beginning. Your variable could also have been created in Qlik Sense as a chart expression.

Proposed action  

The proposed action depends on where and how you are using the variable.

If you need to evaluate a variable inside a Qlik NPrinting report as:

  • a single variable value that can be dragged to the Qlik NPrinting template editor from inside the variable editor
  • a variable field when configuring dynamic naming

There must be an = sign at the start of the variable. This can be added in the Qlik Sense variables overview.

If the variable is used within a Qlik Sense chart as a chart expression, then you must NOT use = to expand the variable. You must create a second, identical variable with the same formula, but a different name.

For example:

  • VarApp1: where sum(sales) is the variable definition. This is the original variable, and remains unchanged.
  • VarApp1b: where =sum(sales) is the variable definition. This new variable can be used together with Qlik NPrinting dynamic naming, or as a single value used in the variable editor inside the Qlik NPrinting report template editor.

You can use a formula in the Qlik NPrinting template editor to expand the variable. However, this method does not apply to dynamic naming.

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!