Aggr Last 12 Months

[#1]

Hi, need some help...

I need the aggr sales expression for the last 12 month...

Can some help me?

Thanks in advance,

FLC

[anbu1984]

Try like this

Aggr({<Date_dim={"$(= '>=' & date(Today()-365) & '<=' & date(Today()))"}>}Sales,Dim)

[#3]

I formulate the question badly, I found the way in the time dimension table:

Aggr(sum(sales), MATid)

Thanks any way...

[hic]

I would define a relative Month already in the script:

   12*(Year(Today())-Year(Date)) + Month(Today()) - Month(Date) as MonthsAgo,

then your expression would be

   Sum({$<MonthsAgo={">=0<12"}>} Sales)

See more on:

* http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

* http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/11/when-should-the-aggr-function-not-be-u...

HIC