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

Thsmi_ — Fri, 14 Mar 2025 01:58:17 GMT

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

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

henrikalmen — Fri, 14 Mar 2025 08:05:41 GMT

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?

topic Re: How to Show All Months in Pivot Table Despite Month Filter Selection in App Development

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

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