topic Re: Calculating average in weekly reporting of count of examinations in QlikView

Calculating average in weekly reporting of count of examinations

Tue, 04 Aug 2015 16:00:06 GMT

Hi QV-Experts

I try to calculate the average of the count of examinations in our radiology department on a weekly basis.

So I would like to show the count of examinations for each week with a bar chart. The weekly average of these examinations/week should be shown as a horizontal line.

I know, that I can use the standard function "Average" (see screenshot, green markers). But my problem is, that I want to use specific colors for the different years (dark blue for current year, light blue for previous year, different shades of grey for older years). I can set these colors for the bar chart, but for the average line QV sets the color automatically. So I have different colors for the bars and the average line for e.g. the year 2015.

Does anybody have a good idea to solve this problem.

Thank you.

Achim

Re: Calculating average in weekly reporting of count of examinations

sinanozdemir — Tue, 04 Aug 2015 16:30:26 GMT

Hi Achim,

To start, first uncheck the trendlines from the trendlines.

Then go to Presentation tab, you will see "Reference Lines", click "Add":

In the next window, you will be able to set your expression, color and label for the reference/trendline:

Hope this helps.

Re: Calculating average in weekly reporting of count of examinations

Wed, 05 Aug 2015 16:43:39 GMT

Hi Sinan

That works perfect. I still struggle a bit with the expression to calculate the right average per year (still learning). But the method you showed me is exactly what I was looking for.

Thanks a lot.

Achim

Re: Calculating average in weekly reporting of count of examinations

sinanozdemir — Wed, 05 Aug 2015 16:46:38 GMT

You are welcome.