Set analysis date with aggr function

Mon, 09 May 2016 10:31:10 GMT

Hi,

I need some help with ignoring selections.

my expression is:

sum({<Year=, Date={">=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))"}>} aggr( invQTY, invID, invQTY))

In this expression I want to ignore the year, but it doesn't work.

If I replace: aggr( invQTY, invID, invQTY) with: invQTY, it's working.

What am I doing wrong?

Thanks.

Re: Set analysis date with aggr function

sunny_talwar — Mon, 09 May 2016 15:29:33 GMT

May be try this:

Sum({<Year=, Date={">=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))"}>} Aggr(Only({<Year>} invQTY), invID, invQTY))

topic Set analysis date with aggr function in QlikView

Set analysis date with aggr function

Re: Set analysis date with aggr function