topic Find average from multiple variables in QlikView

Find average from multiple variables

Anonymous — Wed, 09 Aug 2017 14:33:53 GMT

Hello

I am looking at multiple variables which have a similar field

example.

A B C

1 d 5.0

2 e 6.0

2 f 2.0

3 g 5.0

3 h 3.0

4 i 1.0

4 j 8.0

4 k 7.0

Right now I can find the sum of 1 as there is only one so the sum is 5.0

I want it to eventually show

1 - 5.0

2 - 8.0

3 - 8.0

4 - 16.0

I think i could do it by using an expression but not too sure

If anyone can help it would be appreciated

Anil_Babu_Samineni — Wed, 09 Aug 2017 14:42:44 GMT

Why not simply Sum(C)

vishsaggi — Wed, 09 Aug 2017 14:55:02 GMT

AS Anil suggested use straight table chart with Dimension as A and Expr: Sum(C) you will get as below.

Anonymous — Thu, 10 Aug 2017 07:34:59 GMT

Hello

Sorry I made a mistake

I want to be able to transfer these details to a map which uses A to map the locations Area onto

Right now it shows A details on the map but all the other areas are blank

mbrdenmark — Thu, 10 Aug 2017 12:01:38 GMT

What kind of "map" are you referring to?

What if you use Aggr() as part of your expression to force just one value by each group?

Aggr(sum(C),)

Alternatively you could create a new table with the aggregated values in your load script.

Load

Sum(C) as C

Resident YourTable

Group by A;