Table summary - how to do it?

[exfosteve]

I have the following Table structure loaded, and I want to build a straight table with the structure below.  I've been trying to get this to work with aggr(), but I haven't been able to figure it out.  any help would be greatly appreciated.

system	type 1	Type2
A	1
A	5
B	2
B	3
C	7
C	5
A		3
A		5
B		2
B		8
C		6
C		4

System	avg(Type 1)	avg(type 2)
A	3	4
B	2.5	5
C	12	5

[tresesco · Accepted solution]

A simple straight table should work.

Dim: System                   

Exp1: Avg([Type 1]

Exp2: Avg([Type 2])

[jonathandienst]

And simply using the Avg()'s as in your post does not work? What output do you get and what do you require? Why do you think that you need an Aggr()?

Remember the Qlik engine is case sensitive, so [type 1] and [Type 1] are different fields. Same applies to Type2 and [type 2].

[shiveshsingh]

Your expected output for system C, type1 is wrong.. It should be 6.

Now use Avg([Type 1], Avg([Type 2]) as ur expression.

[ahammadshafi]

Hi Steve:

Is it something you are looking for?