Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Table Values Average - Aggregation

Hi all,

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

qvtable.jpg

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:

qvtableedit.jpg

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Table Values Average - Aggregation

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.

2 Replies
MVP
MVP

Re: Table Values Average - Aggregation

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.

Not applicable

Re: Table Values Average - Aggregation

That has worked perfectly, thanks!