Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Find average from multiple variables

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

4 Replies
Anil_Babu_Samineni

Why not simply Sum(C)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vishsaggi
Champion III
Champion III

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

A Sum(C)
37
15
28
38
416
Anonymous
Not applicable
Author

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
Contributor III
Contributor III

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

     A,

     Sum(C) as C

Resident YourTable

Group by A;