Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alessandro_mari
New Contributor III

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
MVP
MVP

Re: Nested Aggregation

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

Re: Nested Aggregation

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

Community Browser