Table Values Average - Aggregation

[#1]

Hi all,

I have only very recently began learning QlikView and need some help with the following table:

As it stands the responses are showing one row per response. So each column shows each individual score - what I need is an average - so that the table will look like this:

Is this possible with an expression/aggregation? Will the null values affect the average?

Please bear in mind that I'm pretty much a beginner, so try to keep the explanations simple!

Any help is much appreciated.

Message was edited by: smoore009 14:41

[swuehl · Accepted solution]

I assume you are using ResponseID or something similar as dimension.

And then just the field names like [Credit Products] as expression or ...?

Try creating a straight table chart with no dimension and as expressions

=avg([Credit Products])

=avg([Banking and Deposits])

etc.

[#3]

That has worked perfectly, thanks!