topic Re: Previous Previous Month Sale using SetExpression Help in QlikView

Previous Previous Month Sale using SetExpression Help

kakani87 — Thu, 08 Mar 2018 11:11:14 GMT

Hi Folks,

I want to show previous previous month sale

The following expression is for previous month and tried using -2 instead -1 this is showinng the previous month sale only

Any help regarding this

sum

(

CalendarMonthAndYear={'$(=DATE(Max(CalendarMonthAndYear)-1,'MMM YYYY'))'}

sales_total

)

Regards,

Kishore.

prma7799 — Thu, 08 Mar 2018 11:24:31 GMT

Try like this

=SUM({$<MonthName=, [Posting Date]={">=$(=MonthStart(max([Posting Date]),-2))<=$(=(addmonths(max([Posting Date]),-2)))"}

>}[Gross Sales Amount])

tresB — Thu, 08 Mar 2018 11:26:30 GMT

Try like:

sum

(

CalendarMonthAndYear={"$(=DATE(AddMonths(Max(CalendarMonthAndYear),-2),'MMM YYYY'))"}

sales_total

)

kakani87 — Thu, 08 Mar 2018 11:48:27 GMT

Thank you Tresesco