topic Re: Prior Month sales in text box in Water Cooler

Prior Month sales in text box

Krish — Mon, 02 Mar 2020 09:27:41 GMT

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)

Re: Prior Month sales in text box

prma7799 — Mon, 02 Mar 2020 10:11:58 GMT

Try this

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

Re: Prior Month sales in text box

Krish — Thu, 03 Nov 2022 13:05:04 GMT

Can you try the below code

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