topic Re: Average Count in QlikView

Average Count

Mon, 22 Apr 2013 08:50:23 GMT

I am trying to find the average using count for the following

Count({<TERM_CODE_EFF={'2012-13'},COLLEGE_CODE={'AF','BF','HF','SF'},[No Attendance]={'X'}>}[No Attendance])/Count(Total{<TERM_CODE_EFF={'2012-13'},COLLEGE_CODE={'AF','BF','HF','SF'},[No Attendance]={'X'}>}[No Attendance])

However I am not gettign the result I expect though I have used thsi tryp of Set Analysis sucessfully in the past

Re: Average Count

Gysbert_Wassenaar — Mon, 22 Apr 2013 14:26:44 GMT

Your expression returns only one number, not an average. Try something like avg(aggr( myexpressionhere, mydim1, mydim2) and replace myexpressionhere with your expression and mydim1,mydim2 with the dimensions of your chart.

Re: Average Count

Tue, 23 Apr 2013 08:19:36 GMT

That worked a treat thank you