Prior Month sales in text box

[Krish]

Hi,

I am trying to get sum of sales (prior year same month) in Qlikview, but it doesn't work.

Eg: If I select month as Feb  (year is a separate selection which is 2020) then I should get the sum of sales of 2019 Feb.

Below is the one I tried.

=SUM({< Month= {"$(=Date(AddMonths(Max(Month), -1), 'MMM'))"}>}sales)

[prma7799 · Accepted solution]

Try this

Sum({<Year=,Month=,Date={">=$(=AddYears(MonthStart(max(Date)),-1)) <=$(=AddYears(max(Date),-1))"} >} sales)

[Krish]

Can you try the below code

​Num(sum({$<Quarter=,Year=,Month=,MonthYr=,Date = {">=$(=monthstart(addmonths(max([Date]),-1)))<=$(=MonthEnd(addmonths(max([Date]),-1)))"}>} sales),'#,###.###'))​