topic Average of a field in QlikView

Average of a field

Mon, 25 Jan 2016 05:08:28 GMT

Hello, I am fairly new to QlikView and I wouldn't be posting a question if I could find an answer. I need to add a column to a table that has values for each row equal to the average of the values of the previous column. Example of what I need to accomplish(underlined):

Name Value Mean

A 2 3

B 3 3

C 4 3

Thank you for the help in advance!

Re: Average of a field

sunny_talwar — Mon, 25 Jan 2016 11:18:50 GMT

May be this:

Table:

LOAD Name,

Value

From Source;

Join (Table)

LOAD Avg(Value) as Mea

Resident Table;

Re: Average of a field

luizmendes118 — Mon, 25 Jan 2016 11:24:21 GMT

Try this in 'Mean' Expression

AVG(Total(Value))

Re: Average of a field

Anonymous — Mon, 25 Jan 2016 11:25:16 GMT

Sunny, Avg() function does not required any grouping?

like this?

LOAD Avg(Value) as Mea

Resident Table

group by Dimension;

Re: Average of a field

sunny_talwar — Mon, 25 Jan 2016 11:26:59 GMT

I have no fields listed in my load, so in this case Group By is not required. If I did have a non-aggregating field, then Yes you are right, I would need a Group By statement.

Re: Average of a field

Mon, 25 Jan 2016 11:45:07 GMT

You are right Sunny and even though the OP has asked for this I would have to ask why he would want change at script level. If this is suppose to dynamically change based on filters in the model then Luiz approach is correct, otherwise mean-of-mean (average of an average) would take place

Re: Average of a field

Anonymous — Mon, 25 Jan 2016 12:29:25 GMT

Ohh..okay, did not noticed that you are taking single field only in resident

Re: Average of a field

Tue, 26 Jan 2016 04:50:39 GMT

I only need this at script level, it does not get to the model, for I only need to export data to a qvd, not display it. Thank you though for your response.