topic Avg Question in QlikView https://community.qlik.com/t5/QlikView/Avg-Question/m-p/146913#M25389 <HTML><HEAD></HEAD><BODY><P>I think the attached is what you're looking for. To get the count of months, I expanded your calendar to include all dates in 2008. To handle switching from months to weeks, I added a visit_period cyclic group. Then I used this expression:</P><P>count(distinct visit_date) / count(total distinct visit_period)</P></BODY></HTML> Tue, 23 Jun 2009 05:50:51 GMT johnw 2009-06-23T05:50:51Z Avg Question https://community.qlik.com/t5/QlikView/Avg-Question/m-p/146912#M25388 <HTML><HEAD></HEAD><BODY><P>Hi,<BR /><BR />I'd like to calculate the average of visitors.<BR />A visit should only be counted if it's on different days. e.g. Elvis P. visited 2x on 20.05.2008 -&gt; 1 Visit<BR />I would like to calculate the average per visitor dependent on the selected date/ date range.<BR /><BR />Average for Elvis P.:<BR />=========================<BR />Elvis visited on 02.01.2008, 03.01.2008, 05.05.2008, 22.05.2008, 31.07.2008<BR /><BR /><BR />Average 01/2008: 2<BR />Average 05/2008: 3<BR /><BR />Average 01/2008 - 06/2008 = 5/2(Months) = 2.5<BR />Average 2008: 6/12 = 0.5<BR /><BR />Is there a way to get this dynamic so that I can switch from months to calendar weeks.<BR />I guess I also have to use a calendar script in this case?<BR /><BR />Thanks<BR /><BR />Regards.<BR /><BR />Aloah</P></BODY></HTML> Tue, 16 Jun 2009 20:39:58 GMT https://community.qlik.com/t5/QlikView/Avg-Question/m-p/146912#M25388 2009-06-16T20:39:58Z Avg Question https://community.qlik.com/t5/QlikView/Avg-Question/m-p/146913#M25389 <HTML><HEAD></HEAD><BODY><P>I think the attached is what you're looking for. To get the count of months, I expanded your calendar to include all dates in 2008. To handle switching from months to weeks, I added a visit_period cyclic group. Then I used this expression:</P><P>count(distinct visit_date) / count(total distinct visit_period)</P></BODY></HTML> Tue, 23 Jun 2009 05:50:51 GMT https://community.qlik.com/t5/QlikView/Avg-Question/m-p/146913#M25389 johnw 2009-06-23T05:50:51Z