Conditional rendering

Shows or hides a region of a worksheet - what the add-in calls a conditional section - only when a condition you set against live Qlik data is true.

Where to find it

In the KPImailer pane, select the cells that make up the section and give it a condition.

How it works

Pick a Qlik measure or dimension, a comparator, and a value to compare against - the same rule-builder concept used for section conditions on a report’s canvas and for send rules. When the template runs, KPImailer evaluates the condition against current data: the section renders if it’s true, and is skipped if it isn’t.

Worked example

A workbook’s “Needs attention” block should only appear when there’s something to flag. Its condition is set to Sales vs target is less than 90% - most runs the block is empty and skipped, and in a slow month it renders with the underperforming rows.

Tip

Conditional sections control part of a sheet. To stop an entire sheet from generating, use a sheet repeater scoped to a field that excludes it, or gate the whole attachment with a report-level send rule instead.