Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be using set analysis
Sum({<MonthYear = {">=$(=Date(MonthStart(Max(MonthYear), -5), 'MMM-YY'))<=$(=Date(Max(MonthYear), 'MMM-YY'))"}>} Sales)
May be using set analysis
Sum({<MonthYear = {">=$(=Date(MonthStart(Max(MonthYear), -5), 'MMM-YY'))<=$(=Date(Max(MonthYear), 'MMM-YY'))"}>} Sales)