topic Last months sale in QlikView

Last months sale

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Using below am getting last year Last month sale (28-FEB-16) but am not getting 29-feb-16 day of sale.

What i want to make changes in this

Thanks

Re: Last months sale

tyagishaila — Wed, 01 Mar 2017 10:15:04 GMT

to get 29 feb 16 you have to use MonthEnd().

for better understanding share sample data and required output.

Re: Last months sale

tresB — Wed, 01 Mar 2017 10:27:39 GMT

Try like (change highlighted in red):

(SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},Quarter=
,[Posting Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12))<=$(=MonthEnd(addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),-12)))"}
>}[Gross Sales Amount])