Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
That has worked perfectly, thanks!