# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for
Did you mean:
Highlighted
Partner

## Nested Aggregation

Hi everybody,

I have to calculate the max value of the following exspression but in sense it's not possible to use nested aggregation, how can I solve it?

(budget-

SUM({\$<Type={"S"}>}

if(

(month(DateCalendar)<=Month(vDateSet) and year(DateCalendar)=year(vDateSet)

or month(DateCalendar)>=Month(vDateRolling) and year(DateCalendar)=year(vDateRolling))

,Amount)))

/

budget

2 Replies
Highlighted
MVP

Nested aggregation? What are you trying to do? May be provide a sample with expected output

Highlighted
MVP & Luminary

Maybe this:

max(aggr(

(budget-

SUM({\$<Type={"S"}>}

if(

(month(DateCalendar)<=Month(vDateSet) and year(DateCalendar)=year(vDateSet)

or month(DateCalendar)>=Month(vDateRolling) and year(DateCalendar)=year(vDateRolling))

,Amount)))

/

budget,

YourDimensions))

- Marcus