Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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 (2)
1 Solution

Accepted Solutions
goncalo_ricardo_pereira

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

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