Displaying 6 months data in Bar chart

[LP27]

Hi Qlikers,

<Qlik Sense>

I have got Bar chart with Group as Store_Names, Bar as MonthYear and measure as Sum(Sales).

[MonthYear format is MMM-YY] in data.

I need to display only 6 months data in bar chart. Could some one guide me how I can do this and where i should write the expression and so on.

Note: I am new to Qlik Sense environment.

Thanks in advance,

LP

[sunny_talwar · Accepted solution]

May be using set analysis

Sum({<MonthYear = {">=$(=Date(MonthStart(Max(MonthYear), -5), 'MMM-YY'))<=$(=Date(Max(MonthYear), 'MMM-YY'))"}>} Sales)