Display last 12 months data - qliksense

[balajisj30]

Hello People

I want to display last 12 months sales data of different categories in a line chart. So i wrote the set analysis expression,

Sum( {$<month1={">=$(=MonthStart(AddMonths(Max(month1),-12)))"}*{"<$(=MonthEnd(Max(month1)))"}>} sales)

I get last 12 months data when i select month filter but the categories are not getting displayed.

Please help me solve this issue.

[prma7799]

Please try this

SUM({$< MonthName=, Year={$(=max(Year)-1)},Quarter=

,[month1]={">=$(=MonthStart(max([month1),-12))<=$(=Monthend(addmonths(max([month1]),-12)))"}

>}[sales]

[balajisj30]

No. the code is not working. It gives me only selected month and selected - 12th month sales data. Even then categories are not getting displayed.

[prma7799]

Please share some sample app.