topic Re: Table Values Average - Aggregation in QlikView

Table Values Average - Aggregation

Mon, 11 Feb 2013 14:37:34 GMT

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

Re: Table Values Average - Aggregation

swuehl — Mon, 11 Feb 2013 14:48:17 GMT

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.

Re: Table Values Average - Aggregation

Mon, 11 Feb 2013 14:52:21 GMT

That has worked perfectly, thanks!