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: 
Not applicable

count for a certain selected year/month

I'm having trouble writing a set analysis.

I want to calculate the avg(sum(weight)) for this year or for a selected month.

The month is also a calculated field: month(empty_date)

Because emprt_date is a timestamp.

Can anyone help me write this?

1 Reply
datanibbler
Champion
Champion

Hi,

sum() is an aggregation function as is avg() - you can't put one around the other afaIk. Try

>>> aggr(sum(weight), month) <<<

instead.

HTH

Best regards,

DataNibbler