topic Re: Current Month vs Last Month in QlikView

Current Month vs Last Month

Wed, 25 Nov 2020 16:16:04 GMT

Hi , I have the following expression to obtain Last Month based on the selected Month:

sum({<Month={$(=Month(AddMonths(Max(OrderDate),-1)))}>}Sales)

But, when the selected Month = January, it does not change the year.

The correct result should be December of the past year

Thanks

girirajsinh — Thu, 19 Jan 2017 20:25:05 GMT

Try

sum({<Month={$(=Month(AddMonths(Max(OrderDate),-1)))},YearField={$(=Year(AddMonths(Max(OrderDate),-1)))}<>}Sales)

MK9885 — Thu, 19 Jan 2017 20:28:58 GMT

Do you have Master Calendar script in place to deal with dates?

If yes?

Then use

if(InMonth(TempDate, today(),-1), 1, 0) as LastMonthFlag,

In your Master script

And in front end use

sum({<LastMonthFlag={1}>}Sales)

Anonymous — Thu, 19 Jan 2017 20:48:30 GMT

Are the numbers accurate and just the column header wrong?