Qlik Community

Qlik Sense Data Connectivity

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

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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