topic Average representation in Bar Chart in QlikView

Average representation in Bar Chart

Wed, 20 Nov 2013 16:42:21 GMT

Hi,

I want to represent avaerage of a column in bar chart, below is the requirment.

I am loading data from excel file where I am having 3 columns, 1. Request Number, 2. Request Owner , 3. Request group.

I need the average of lists handeled by team as well as by individual request owner in bar chart. Below is the sample data.

Request Number	Request Group	Request Owner
300-12696	BUSAPPS-ABC	abhi
300-12697	BUSAPPS-ABC	Raj
300-11872	BUSAPPS-ABC	abhi
300-12032	Busapps-XYZ	Abhi
300-12057	Busapps-XYZ	Sam
300-12014	Busapps-XYZ	Sam
300-11470	Busapps-XYZ	Joy
300-8867	Busapps-XYZ	Roy
300-9017	Busapps-XYZ	Sam

Can anyone please help me with this?

Thanks in advance.

Regards,

Abhi

Re: Average representation in Bar Chart

Thu, 21 Nov 2013 03:24:45 GMT

Hi Can anyone please help me on this, its quite urgent.

Thanks in advance.

Regards,

Abhishek

Re: Average representation in Bar Chart

tresB — Thu, 21 Nov 2013 04:27:03 GMT

Your input is understood. Could you post the expected output as well?

Re: Average representation in Bar Chart

Thu, 21 Nov 2013 06:04:18 GMT

Hi Tresesco,

The output is nothing but the average of request number handled by group Vs average of request number handled by request owner.

E.g. if there are 50 requests in a group and I handled 17 out of 50 and we have 4 people (include me) in team then I want average of complete 50 request handled by team Vs average of 17 request handled by me and want to represent it in a graph.

Thanks,

Abhi

Re: Average representation in Bar Chart

sundarakumar — Thu, 21 Nov 2013 14:29:53 GMT

Hi Tresesco,

Hope the attachment will help...

Sundar