topic Re: Index chart - months displayed not being restricted in App Development

Index chart - months displayed not being restricted

zakpullen — Tue, 02 Dec 2025 11:07:06 GMT

Hi,

This index chart worked perfectly well in Qlikview, but in Qlik Sense there is an issue with the months displayed. It should only show 12 months as per the expression. As you can see in the image below, the calculation is working for the 12 months, but the axis is displaying all possible months.

The dimensions are MonthYear (date) and Directorate. The expression is as follows:

Only({1}

Aggr(Sum({<Year=,Month=,FY=,FMonth=,MonthYear={">=$(=Date(MonthStart(Max(MonthYear),-11),'MMM-YY'))<=$(=Date(MonthStart(Max(MonthYear)),'MMM-YY'))"}>} FTE)

(Top(Sum({<Year=,Month=,FY=,FMonth=,MonthYear={">=$(=Date(MonthStart(Max(MonthYear),-11),'MMM-YY'))<=$(=Date(MonthStart(Max(MonthYear)),'MMM-YY'))"}>} FTE))/100)

, Directorate, MonthYear)

)

I've played with the axis settings, etc, and nothing will give me just the 12 months covered by the expression. I'm wondering if a change to the expression might help. Any ideas?

Thanks

Re: Index chart - months displayed not being restricted

pablolabbe — Tue, 02 Dec 2025 12:34:50 GMT

Have you tried to disable the continuous axis property ?

Also try to disable "include null values" in the MonthYear dimension property

Re: Index chart - months displayed not being restricted

zakpullen — Tue, 02 Dec 2025 15:06:45 GMT

Disabling continuous axis hadn't worked, but disabling null values as you suggested did deal with all the months prior to the range with data initially. Months after the range with data (as per date selection) did still appear. So this was progress. However, the progress disappeared after more playing around, and I've not been able to replicate it yet. So a bit of Qlik Sense inconsistency has also crept in.

Thanks

Re: Index chart - months displayed not being restricted

pablolabbe — Tue, 02 Dec 2025 18:27:30 GMT

why your expression starts with Only( and have an {1} ? Are you trying to avoid selections in this chart ?

Re: Index chart - months displayed not being restricted

pablolabbe — Tue, 02 Dec 2025 18:28:30 GMT

Can you show how the chart is displayed now ?