topic CurrentYear MaxMonth vs LastYear MaxMonth in QlikView

CurrentYear MaxMonth vs LastYear MaxMonth

Wed, 26 Nov 2014 13:43:33 GMT

Hi Community

I have difficulty to get the result that i want. Below is the result table, basically what i want is to show the Last Month sales amount for each year. The last month for 2008-> Dec, 2009->Dec, 2010-> Jun. Attached with the data and qvw. Thanks in advance.

Year	CurrentYear	Last year
2008	136,136	0
2009	105,083	136,136
2010	86,978	105,083

Re: CurrentYear MaxMonth vs LastYear MaxMonth

Thu, 27 Nov 2014 03:04:26 GMT

Anyone can help me on this?

Re: CurrentYear MaxMonth vs LastYear MaxMonth

kushalthakral — Thu, 27 Nov 2014 03:30:09 GMT

Hi John

Will try with the data provided with you and revert you back with solution

Regards

Kushal T

Re: CurrentYear MaxMonth vs LastYear MaxMonth

kushalthakral — Thu, 27 Nov 2014 05:34:25 GMT

Hi John

First you convert months in number by using num(month(Date))

and then use the following expression

=sum({<MonthNo={$(=(Max(MonthNo)))}>}Sales)

Re: CurrentYear MaxMonth vs LastYear MaxMonth

Thu, 27 Nov 2014 11:30:43 GMT

Hi Kushal

I have tried but it doesn't give me the correct result.