Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Error: Nested Aggregation not allowed

Hello guys,

I'm using the following expression on a table chart to collect the Growth Rate, and it's working perfectly:

=rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1))

My Table chart has the following dimension:

=if(Date(AsOfDVPG)>today(),'',Date(AsOfDVPG))

 

I'm trying to show the last available Growth Rate, when the user select a specific field. For that I'm trying to use the following expression:

= FirstSortedValue(
rate(3,0,-Avg({<Flag = {'3 Year Ago'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1),Avg({<Flag = {'Current'}>} LOPP/IGPD)* FirstSortedValue(TOTAL IGPD, -DVPG, 1))
-DVPG, 1)

But I'm getting an error: "Error: Error in Expression: Nested aggregation not allowed"

Nested.png

How can I do that?

How can I show the last available Growth Rate on a FieldBox?
In this example, I'm expecting to see the 1.25%.

 

Thanks

2 Replies
brunolelli87
Creator II
Creator II
Author

Hello folks,

Do you guys have any idea about how can I solve it?

 

Thanks

brunolelli87
Creator II
Creator II
Author

Any idea guys?