Displaying 6 months data in Bar chart

LP27 — Sat, 16 Nov 2024 05:41:44 GMT

Hi Qlikers,

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,

Re: Displaying 6 months data in Bar chart

sunny_talwar — Fri, 31 May 2019 12:02:00 GMT

May be using set analysis

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