topic aggregated averages in QlikView https://community.qlik.com/t5/QlikView/aggregated-averages/m-p/1388859#M458973 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>im trying to make a direct day to day comparison 2106 - 2017 where my only dimensions are MonthNum, DayNum</P><P>I have the total number of parcels per day for each year.</P><P>I cant get the table to calculate the average number of parcels per day of the week of the respective year.</P><P></P><P>WekkdayNum 0 as Monday</P><P></P><P>eg:</P><P>MonthNum / DayNum / Weekday2016 / Weekday2017 / avg no of parcels per weekday 2016 / avg <SPAN style="font-size: 13.3333px;">no of parcels per weekday 2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">1 / 13 / 2 / 4 / avg no of parcels on weekday 2 in 2016 / avg no of parcels on weekday 4 in 2017<BR /></SPAN></P><P></P><P>so far I have tried something like below but without results (no calculation)</P><P></P><P><STRONG>avg( aggr(count( DISTINCT {1 &lt;Year={'$(=year(today())-1)'}&gt;}%ParcelNumber), Year, WeekdayNum))</STRONG></P><P></P><P>attached is the created table with the daily parcel data.</P><P>any help is appreciated.</P><P></P><P>thanks,</P><P>Lucas</P></BODY></HTML> Tue, 14 Nov 2017 17:36:18 GMT Anonymous 2017-11-14T17:36:18Z aggregated averages https://community.qlik.com/t5/QlikView/aggregated-averages/m-p/1388859#M458973 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>im trying to make a direct day to day comparison 2106 - 2017 where my only dimensions are MonthNum, DayNum</P><P>I have the total number of parcels per day for each year.</P><P>I cant get the table to calculate the average number of parcels per day of the week of the respective year.</P><P></P><P>WekkdayNum 0 as Monday</P><P></P><P>eg:</P><P>MonthNum / DayNum / Weekday2016 / Weekday2017 / avg no of parcels per weekday 2016 / avg <SPAN style="font-size: 13.3333px;">no of parcels per weekday 2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">1 / 13 / 2 / 4 / avg no of parcels on weekday 2 in 2016 / avg no of parcels on weekday 4 in 2017<BR /></SPAN></P><P></P><P>so far I have tried something like below but without results (no calculation)</P><P></P><P><STRONG>avg( aggr(count( DISTINCT {1 &lt;Year={'$(=year(today())-1)'}&gt;}%ParcelNumber), Year, WeekdayNum))</STRONG></P><P></P><P>attached is the created table with the daily parcel data.</P><P>any help is appreciated.</P><P></P><P>thanks,</P><P>Lucas</P></BODY></HTML> Tue, 14 Nov 2017 17:36:18 GMT https://community.qlik.com/t5/QlikView/aggregated-averages/m-p/1388859#M458973 Anonymous 2017-11-14T17:36:18Z