topic Re: compare last two years in QlikView

compare last two years

Wed, 26 Nov 2014 08:13:41 GMT

Hi,

i want to report the last two years of my value "lineamount" in a chart

my dimensions are year and month

my expressions

Sum({<TCMSALESORDERDATE = {">=$(=MonthStart( AddMonths(Max(TCMSALESORDERDATE),-12)))<=$(=Max(TCMSALESORDERDATE))"}>} LINEAMOUNT)

and

Sum({<TCMSALESORDERDATE = {">=$(=MonthStart( AddMonths(Max(TCMSALESORDERDATE),-24)))<=$(=Max(TCMSALESORDERDATE))"}>} LINEAMOUNT)

i get only one chart in which the values per month are added for the last two years...

can someone help?

amit_saini — Wed, 26 Nov 2014 08:16:25 GMT

Andreas,

Check this:

Thanks,

jagan — Wed, 26 Nov 2014 09:05:50 GMT

Hi,

Try this expressions

For last 12 Months:

Sum({<TCMSALESORDERDATE = {">=$(=MonthStart( Max(TCMSALESORDERDATE),-12))<=$(=Date(Max(TCMSALESORDERDATE)))"}>} LINEAMOUNT)

For last 13 to 24 Months:

Sum({<TCMSALESORDERDATE = {">=$(=MonthStart(Max(TCMSALESORDERDATE),-24))<=$(=MonthEnd(Max(TCMSALESORDERDATE), -13)"}>} LINEAMOUNT)

Hope this helps you.

If not working attach some sample file.

Regards,

jagan.