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.
Scenario 1: Variable is being used in Qlik NPrinting Designer
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.
Scenario 2: Variable is a chart expression in Qlik Sense
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.
Scenario 3: Variable as a formula in Qlik NPrinting Designer
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!