topic Re: How to add avg comparison to chart in QlikView

How to add avg comparison to chart

Mon, 09 Nov 2015 08:32:32 GMT

Hi all,

Please have a look at my attached straight forward chart.

What I'd like to achieve is very simple. When I click on an employee, I want the chart to compare that employee to the average of all other employee's. Just not sure how to go about it.

Any help would be appreciated.

Kind Regards,

Re: How to add avg comparison to chart

sunny_talwar — Mon, 09 Nov 2015 14:50:12 GMT

Something like this?

If it is, then I can explain you the changes I made to get to this. If not then help me understand exactly what you want.

Best,

Sunny

Re: How to add avg comparison to chart

morgankejerhag — Mon, 09 Nov 2015 21:25:14 GMT

I think Sunny is close, but one also must remove the currently selected Employee if you want the average of the others. I have modified Sunny's expression to inverse the selection on Employee.

Avg(TOTAL {<Employee = e(Employee)>} Aggr(sum({<Employee = e(Employee)>} CallHours), Month, Employee))