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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
JoseGarcia
Creator III
Creator III

nested aggregation

Hi,
Expression below is giving me nested aggregation error.

Could anyone assist?
thanks 

=avg(sum([EightD.Date_Creation])- sum([EightD.D1_KPIDate])) 

Labels (1)
3 Replies
Channa
Specialist III
Specialist III

why you are using average there remove that avg

Channa
JoseGarcia
Creator III
Creator III
Author

If no selection made, I need average time.
MarcoWedel

You need to elaborate on your actual requirement.