Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
chan103148
Contributor III
Contributor III

avg(aggr(sum( in set anaylsis

hi,

whats wrong with this script? it's not working

please help me

avg(Aggr(Sum({$<[Date.autoCalendar.YearMonth]={"2019-Sep"}>}[Traffic In])))

 

 

thank you

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
goncalo_ricardo_pereira
Partner - Contributor III
Partner - Contributor III

Hi,

You missing the dimension on your Aggr funtion.

avg(Aggr(Sum({$<[Date.autoCalendar.YearMonth]={"2019-Sep"}>}[Traffic In]), DimensionForYourAggr))

Best Regards.

Goncalo Pereira

View solution in original post

1 Reply
goncalo_ricardo_pereira
Partner - Contributor III
Partner - Contributor III

Hi,

You missing the dimension on your Aggr funtion.

avg(Aggr(Sum({$<[Date.autoCalendar.YearMonth]={"2019-Sep"}>}[Traffic In]), DimensionForYourAggr))

Best Regards.

Goncalo Pereira