topic Re: Averaging fields in a table in QlikView

Averaging fields in a table

Thu, 20 Nov 2014 06:27:55 GMT

Hi,

I got a table as below, I want to average those values

Eg: avg(A), avg(B)

but if I got a N/A figure on the column I want to avg only the values

Eg: In column B I want to avg values 10, 8, 8

In column C I want to avg values 5, 0, 7

Can any one tell me how do I do it, Thanks in advance...

A	10	9	10	8
B	10	N/A	8	8
C	5	N/A	0	7

Re: Averaging fields in a table

anbu1984 — Thu, 20 Nov 2014 06:32:42 GMT

Are A,B,C field names or 3 different rows?

Re: Averaging fields in a table

Thu, 20 Nov 2014 06:37:15 GMT

Hi Mazaf,

Do you want a total?

or these values are in the field?

By default qlikview take the avg of the values which are present

I mean: for B (10+8+8)/3

with Reagrds

harshita Gaur

Re: Averaging fields in a table

anbu1984 — Thu, 20 Nov 2014 06:37:20 GMT

Load Avg(A),Avg(B),Avg(C) Inline [

A,B,C

10,10,5

9,N/A,N/A

10,8,0

8,8,7 ];

Re: Re: Averaging fields in a table

Thu, 20 Nov 2014 06:39:56 GMT

see the attached file

Re: Averaging fields in a table

Thu, 20 Nov 2014 07:12:11 GMT

Hi Harshita,

I want avg not total but if the field had a values 'N/A' I want skip that field and avg other figures

in your example you haven't mentioned 'N/A' in the field

Re: Averaging fields in a table

Thu, 20 Nov 2014 07:19:52 GMT

did you check the attached qvw. qlikview by default generate the avg of field which has values

Regards

harshita Gaur

Re: Averaging fields in a table

Thu, 20 Nov 2014 07:25:28 GMT

Hi mufaz,

if you don't get the values then try this

=sum(A)/count( {<A-={''}>}A)

With Regards

Harshita Gaur

Re: Re: Averaging fields in a table

Thu, 20 Nov 2014 07:29:09 GMT

see the attached file