topic Re: AVERAGE ISSUE in QlikView https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471935#M488190 <HTML><HEAD></HEAD><BODY><P>Thanks this works!! </P><P></P><P>Do you have also a suggestion to calculate this in case days are split in morning, -7-16, evening,17-24,</P><P>night 1- 6?</P></BODY></HTML> Sun, 30 Dec 2012 09:35:06 GMT 2012-12-30T09:35:06Z AVERAGE ISSUE https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471933#M488188 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>how can I calculate the average product sold in one month ,&nbsp; where the divisor is not only the dates where the product is sold, but the total number</P><P>of dates in that period. </P><P></P><P>see abstracted example</P><P></P><P>Thanks in advance!</P></BODY></HTML> Sun, 30 Dec 2012 08:21:59 GMT https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471933#M488188 2012-12-30T08:21:59Z Re: AVERAGE ISSUE https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471934#M488189 <HTML><HEAD></HEAD><BODY><P>Try: sum(Customer)/interval(monthend(max(Date))-monthstart(min(Date))-1,'D')</P></BODY></HTML> Sun, 30 Dec 2012 09:12:58 GMT https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471934#M488189 Gysbert_Wassenaar 2012-12-30T09:12:58Z Re: AVERAGE ISSUE https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471935#M488190 <HTML><HEAD></HEAD><BODY><P>Thanks this works!! </P><P></P><P>Do you have also a suggestion to calculate this in case days are split in morning, -7-16, evening,17-24,</P><P>night 1- 6?</P></BODY></HTML> Sun, 30 Dec 2012 09:35:06 GMT https://community.qlik.com/t5/QlikView/AVERAGE-ISSUE/m-p/471935#M488190 2012-12-30T09:35:06Z