topic Re: Average headcount over a period in QlikView

Average headcount over a period

Mon, 23 Jul 2012 17:57:15 GMT

Hi All -

Thanks in advance for your help!

I'd like to have 2 charts - one showing headcount for Jan, Feb and Mar.

The second showing average headcount for Q1.

I'm using this expression:

= Count ({$< STATUS = {"Active","LOA"} > } DISTINCT EEID )

In chart one, i'm using dimension = month (e.g. 01/01/12)

In chart two, i'm using dimension = quarter(e.g. 2012Q1)

In chart one, i'm using the 'average' plot for trend. I want this same value showing in chart2.

How do i do it?

See attached pic for more clarity. Thanks!

Pat

goldnejea8 — Mon, 23 Jul 2012 18:43:55 GMT

Try using the aggr() function. Then you can get the average over a period of time.

AVG(aggr(Count ({$< STATUS = {"Active","LOA"} > } DISTINCT EEID ) ,Month))

Mon, 23 Jul 2012 19:19:50 GMT

Worked like a charm. Thanks!

goldnejea8 — Mon, 23 Jul 2012 19:21:11 GMT

Excellent, glad to hear!