Index chart - months displayed not being restricted

[zakpullen]

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

[pablolabbe]

Have you tried to disable the continuous axis property ?

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

[zakpullen]

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

[pablolabbe]

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

[pablolabbe]

Can you show how the chart is displayed now ?