topic Re: how to calculate last 6 months and next 6 months sales based on my selection? in QlikView

how to calculate last 6 months and next 6 months sales based on my selection?

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

Hi,

I have simple requirement if i select any month i want display last 6 month sales.

Ex:if i select march i want dislpay last 6 month sales like oct,nov,dec,jan,feb and mar.sales i want show. how to write the set expression.

same way if i select any month i want display next 6 month sales.

Ex: If i select June than display june,july ----up to Nov.

Thanks

chaitu

Re: how to calculate last 6 months and next 6 months sales based on my selection?

sunny_talwar — Tue, 17 Apr 2018 02:15:20 GMT

May be this

Last 6 months

Sum({<Date = {"$(='>=' & Date(MonthStart(Max(Date), -6), 'DateFieldFormatHere') & '<=' & Date(Max(Date), 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}Sales)

Next 6 months

Sum({<Date = {"$(='>=' & Date(Max(Date), 'DateFieldFormatHere') & '<=' & Date(MonthStart(Max(Date), 7) - 1, 'DateFieldFormatHere'))"}, Month, Year, MonthYear>}Sales)

Re: how to calculate last 6 months and next 6 months sales based on my selection?

Anonymous — Tue, 17 Apr 2018 06:25:39 GMT

Try this

=Sum({<Date={">=$(=MonthStart(Max(Date),-5))<=$(=MonthEnd(Max(Date),+6))"}>} Sales )

Re: how to calculate last 6 months and next 6 months sales based on my selection?

Anonymous — Thu, 19 Apr 2018 06:43:31 GMT

Hi,

Please see attached QVW. !