topic Re: Average new field on the Script in QlikView

Average new field on the Script

Wed, 24 Jun 2015 16:21:18 GMT

Hi,

I want to create a new field called "AvgPlace" by calculating the average of the values for the places. My data is like this:

Place Store Value

A x 3

A y 2

B z 2

B v 4

B w 3

and I want a new table like this

Place AvgPlace

A 2.5

B 3

I want to do it on the Script, but it just keeo telling me "Invalid Expression"

Re: Average new field on the Script

swuehl — Wed, 24 Jun 2015 16:24:33 GMT

LOAD

Place,

avg( Value) as AvgPlace

RESIDENT YourTable

GROUP BY Place;

Re: Average new field on the Script

Gabriel — Wed, 24 Jun 2015 16:28:07 GMT

Hi,

Try this

Data:

load * Inline [

Place , Store,   Value
A ,         x ,        3
A ,         y,          2
B ,         z ,         2
B ,         v,          4
B,          w,         3
];

NoConcatenate
Data2:
LOAD
Place //If you don't want the tables to join then rename this field
,Sum(Value) / Count(Place) AS AvgValue
Resident Data
Group BY
Place;

Re: Average new field on the Script

Wed, 24 Jun 2015 16:31:02 GMT

You guys are amazing! Thank youu

Re: Average new field on the Script

Wed, 24 Jun 2015 16:34:13 GMT

Thank youuuu