Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
A simple straight table should work.
Dim: System
Exp1: Avg([Type 1]
Exp2: Avg([Type 2])
A simple straight table should work.
Dim: System
Exp1: Avg([Type 1]
Exp2: Avg([Type 2])
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].
Your expected output for system C, type1 is wrong.. It should be 6.
Now use Avg([Type 1], Avg([Type 2]) as ur expression.
Hi Steve:
Is it something you are looking for?