how to show last 6 months Sales in current year and previous year 6 months Sales in line chart

[venky77777]

Hi friends,

how to show last 6 months in current year and the same 6 months in previous year in line chart in Qliksense?

dimension: inv_months

measure1:=Sum({<Inv_Date={">=$(=addmonths(monthstart(Max(Inv_Date)),-6))<=$(=Max(Inv_Date))"}>}Sales)

how to write measure2? for example like below table, need to display in line chart

[Vegar · Accepted solution]

What about  this:

measure2:

=Sum({<Inv_Date={">=$(=addyear(addmonths(monthstart(Max(Inv_Date)),-6),-1) )<=$(= addyear(Max(Inv_Date),-1))"}>}Sales)

[venky77777]

Thanks @Vegar . that's working.

[Vegar]

Glad to help ☺️