topic Re: Average Sales finding in QlikView

Average Sales finding

Thu, 29 May 2014 10:12:22 GMT

Hi I have sales field. and i have jobtype field i want to get

Avg(sales) who is working as Salesman

How can i get

alexandros17 — Thu, 29 May 2014 10:13:50 GMT

Try this (check field and values name)

Avg({$ <jobtype = {'Salesman'}>} sales)

Thu, 29 May 2014 10:20:29 GMT

If i want to calculate Avg(Sales) in the scripting how can i calculated.

its_anandrjs — Thu, 29 May 2014 10:21:15 GMT

Try with this also

=Avg({<jobtype = {'Salesman'}>} sales )

=Avg( If( jobtype = 'Salesman' ,sales ))

its_anandrjs — Thu, 29 May 2014 10:25:38 GMT

See the small example adopt this in your file also

Source:

LOAD * Inline

[

Year,Sales,jobtype

2010,451256,Salesman

2011,258741,Operator

2012,344345,Salesman

2013,545466,Operator

2014,355345,Operator

];

NoConcatenate

Final:

LOAD

jobtype,

Avg(Sales) as AvgSales

Resident Source

Where jobtype = 'Salesman'

Group By jobtype;

DROP Table Source;