Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Partner
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

Thanks in advance for helping

2 Replies
Highlighted

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

Highlighted
MVP & Luminary
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