Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis date with aggr function

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.

1 Reply
sunny_talwar

May be try this:

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