topic Median/Average with Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Median-Average-with-Set-Analysis/m-p/695752#M251446 <HTML><HEAD></HEAD><BODY><P>So here's my situation:</P><P></P><P>I have two charts.</P><P></P><P>A 7 day rolling:</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/68639_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>And a 30 day rolling.&nbsp; What is visible are created/resolved tickets and a daily average and daily median calculation (done using set analysis).</P><P></P><P>However when I try to calculate a 7 day average and median, the numbers are incorrect as compared to doing them by hand.</P><P></P><P>Here is the set analysis I'm using with my calculations as displayed:</P><P style="padding-left: 30px;"><STRONG>Avg({1&lt;[Project ID] = {10320}&gt;} DaysToResolve)</STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P>Now I'm not entirely sure those numbers are right either as the average on Oct-2 on the chart is 11.3 and when I calculate by hand it comes out to 21.25.</P><P><STRONG><BR /></STRONG></P><P>How do I properly calculate the individual days, and a 7 day average for what is displayed?<STRONG><BR /></STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P style="padding-left: 30px;"></P></BODY></HTML> Thu, 09 Oct 2014 20:51:14 GMT 2014-10-09T20:51:14Z Median/Average with Set Analysis https://community.qlik.com/t5/QlikView/Median-Average-with-Set-Analysis/m-p/695752#M251446 <HTML><HEAD></HEAD><BODY><P>So here's my situation:</P><P></P><P>I have two charts.</P><P></P><P>A 7 day rolling:</P><P></P><P><IMG alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/68639_pastedImage_0.png" style="width: auto; height: auto;" /></P><P></P><P>And a 30 day rolling.&nbsp; What is visible are created/resolved tickets and a daily average and daily median calculation (done using set analysis).</P><P></P><P>However when I try to calculate a 7 day average and median, the numbers are incorrect as compared to doing them by hand.</P><P></P><P>Here is the set analysis I'm using with my calculations as displayed:</P><P style="padding-left: 30px;"><STRONG>Avg({1&lt;[Project ID] = {10320}&gt;} DaysToResolve)</STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P>Now I'm not entirely sure those numbers are right either as the average on Oct-2 on the chart is 11.3 and when I calculate by hand it comes out to 21.25.</P><P><STRONG><BR /></STRONG></P><P>How do I properly calculate the individual days, and a 7 day average for what is displayed?<STRONG><BR /></STRONG></P><P style="padding-left: 30px;"><STRONG><BR /></STRONG></P><P style="padding-left: 30px;"></P></BODY></HTML> Thu, 09 Oct 2014 20:51:14 GMT https://community.qlik.com/t5/QlikView/Median-Average-with-Set-Analysis/m-p/695752#M251446 2014-10-09T20:51:14Z Re: Median/Average with Set Analysis https://community.qlik.com/t5/QlikView/Median-Average-with-Set-Analysis/m-p/695753#M251447 <HTML><HEAD></HEAD><BODY><P>Perhaps this document helps: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Fri, 10 Oct 2014 09:43:16 GMT https://community.qlik.com/t5/QlikView/Median-Average-with-Set-Analysis/m-p/695753#M251447 Gysbert_Wassenaar 2014-10-10T09:43:16Z