topic Re: Average of a Count in QlikView

Average of a Count

Wed, 23 Apr 2014 15:35:06 GMT

I want to create a chart where by I count the number of occasions an event has occurred in a given month, based on this count I want to display the average per month over a years period - does anyone know how to perform an Average of a Count

I.E,

3 events in Jan

5 events in Feb

4 events in Mar

Count would return = 12 but the I want to average this result being 4?

Ideally I would then want to show this on a chart so I got the average number of events per year for previous years i.e. 09, 10, 11, 12

And then broken down by month for 2013 and 2014 year to date - any help is welcome

Re: Average of a Count

MK_QSL — Wed, 23 Apr 2014 15:42:21 GMT

Count(events)/Count(Month)

if you provide data, would be easy to answer.

Re: Average of a Count

Wed, 23 Apr 2014 15:56:41 GMT

They are only Counts though - Basically I have to count the number of events on a production line

My attempt is something like this but it is not correct:

AVG (StopType_Label) when Year = "2009

AVG - is the caluclation

StopType_Label is the the data column - but I don't think I can perform the average function when the column is text, but I can count the number of occurrences

Year = another column of data

2009 - a piece of data that should be in the year column

Re: Average of a Count

MK_QSL — Wed, 23 Apr 2014 15:57:44 GMT

Provide sample data along with your requirements. Would love to help you in this problem.

Re: Average of a Count

Thu, 24 Apr 2014 14:12:10 GMT

So I need to record a count per month, but then plot on a graph with averages for previous years, the current average per month for the year to date as well as targets.

Is this possible?

Re: Average of a Count

Thu, 24 Apr 2014 14:14:59 GMT

you could use rangesum etc with a variable to dictate which view you would like i.e. 1 month or a year

Re: Average of a Count

Thu, 24 Apr 2014 14:17:34 GMT

Hi Felim,

Thanks for the reply, I am a newbie to this - could you provide al little more detail.

It's getting the correct syntax etc... that I am struggling with