topic Table summary - how to do it? in QlikView

Table summary - how to do it?

exfosteve — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Table summary - how to do it?

tresB — Mon, 19 Mar 2018 04:48:33 GMT

A simple straight table should work.

Dim: System

Exp1: Avg([Type 1]

Exp2: Avg([Type 2])

Re: Table summary - how to do it?

jonathandienst — Mon, 19 Mar 2018 04:59:04 GMT

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].

Re: Table summary - how to do it?

shiveshsingh — Mon, 19 Mar 2018 06:11:50 GMT

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

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

Re: Table summary - how to do it?

ahammadshafi — Mon, 19 Mar 2018 07:01:43 GMT

Hi Steve:

Is it something you are looking for?