Qlik Community

Ask a Question

Connectivity & Data Prep

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

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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