Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikNewbie15
Contributor
Contributor

Nested Aggregation Not Allowed

hello everyone, 

I'm just new here to Qliksense and was hoping to get some insights on how I could make this expression correct. I am trying to get the quotient of the sum of 2 fields from last month and return the value of 1 whenever the answer is less than or equal 15.

When I use this expression I get the nested aggregation not allowed:

Count(If(Sum({$<[YearDate] = {'$(=Year(Today()))'}, [MonthDate] = {"$(=Month(AddMonths(Today(), -1)))"}>} [Answered Phone in Seconds]) /
Sum({$<[YearDate] = {'$(=Year(Today()))'}, [MonthDate] = {"$(=Month(AddMonths(Today(), -1)))"}>} [Total Phone Calls]) <=15,1))

And when I add the Aggr() function it says that it only takes at least 2 parameters.

Count(Aggr(If(Sum({$<[YearDate] = {'$(=Year(Today()))'}, [MonthDate] = {"$(=Month(AddMonths(Today(), -1)))"}>} [Answered Phone in Seconds]) /
Sum({$<[YearDate] = {'$(=Year(Today()))'}, [MonthDate] = {"$(=Month(AddMonths(Today(), -1)))"}>} [Total Phone Calls]) <=15,1)))

 

Can someone help me correct my expression?

Labels (1)
0 Replies