How to Show All Months in Pivot Table Despite Month Filter Selection

[Thsmi_]

Hi, I'm new to Qlik and need some help. Does anyone know how to make a pivot table display data for all months, even when a specific month is selected in the filter pane?

Currently, when I select only the year filter, the pivot table correctly shows data for all months. However, when I select a specific month, the table only displays data for that month, while all other months show as "-".

Is there a way to ensure that all months remain visible with their respective data, regardless of the month filter selection? Any advice would be greatly appreciated!

The dimension.

The measure.

Pivot table without month filter selected.

Pivot table with month filter selected

[henrikalmen]

Try adding this before the pick statement: {<MONTH={"*"}>}

But I'm not certain it will resolve your issue completely. "ACTUAL (**bleep**)" contains this: MONTH={">=$(=1) <= $(=Max(MONTH))"} and that might not work now. But do you even need that month override at all for this measure?