topic Re: Averages problem in QlikView

Averages problem

Sat, 08 Jun 2013 07:53:37 GMT

I have 3 regions, each of which contains a group of customers. I would like to be able to plot a chart which shows the sales per month by selected indivuidual customer as well as the average per month for the customers region.

Can someone point me in the right direction please.

Thanks for your support

Jim

Re: Averages problem

Gysbert_Wassenaar — Sat, 08 Jun 2013 09:09:30 GMT

Try something like this for calculating the average: sum({<Customer=,Region=p(Region)>}Sales) / count({<Customer=,Region=p(Region)>}DISTINCT Customer)

See attached example. In the example some salepersons have sales in several regions, but John only has sales in Greater London so he fits your scenario.

Re: Averages problem

Sat, 08 Jun 2013 15:05:18 GMT

Brilliant Gysbert, I can't open your attachment as I'm still on Personal Edition in the meantime I'll try to get my head around the logic but it works!

Thanks very much for your help with this. Much appreciated

Jim