topic Re: Avg function not working as expected in QlikView

Avg function not working as expected

Fri, 20 Jun 2014 07:34:16 GMT

Hi everyone,

I have some problems with my expression with the Avg funtion in it.

My formula is: Avg(Aggr([1],[2],[3],[4],[5],[6],[7],[8],[9],[10]))

And it shows an output value but it's not correctly.

I have also some statistic objects which calculates the average of a column and I think that's working fine but in my KPI it's not.

When using a calculator and calculate the average of the statistic object I have another output then my KPI is showing.

Please see the attachment to clear some things up.

The 3 KPI's have all 3 groups of columns(answers) you can see on the right side.

Please ask me if you need further info or another screenshot, thanks a lot!

tresB — Fri, 20 Jun 2014 07:41:39 GMT

Is it a chart or text box you are writing this expression in? If chart, which chart? what are the dimensions?

Fri, 20 Jun 2014 07:45:30 GMT

AGgr function is similar to SQL group by, so you have to a dimension that you r grouping by

thanks

padma

Fri, 20 Jun 2014 07:47:44 GMT

Thanks for the quick reply, I'm using this in the gauge chart and have no dimensions defined.

Fri, 20 Jun 2014 07:49:46 GMT

Thanks for your reply.

So I have to add a group in the dimension tab?

Like this:

Fri, 20 Jun 2014 08:11:35 GMT

is it possible to have sample qvw

regards

padma

Fri, 20 Jun 2014 08:21:28 GMT

Sure, see attachment.

Anonymous — Fri, 20 Jun 2014 08:40:24 GMT

Try Below,

RangeAvg(Avg([1]),Avg([2]),Avg([3]),Avg([4]),Avg([5]),Avg([6]),Avg([7]),Avg([8]),Avg([9]),Avg([10]))

RangeAvg(Sum([1]),Sum([2]),Sum([3]),Sum([4]),Sum([5]),Sum([6]),Sum([7]),Sum([8]),Sum([9]),Sum([10]))

Fri, 20 Jun 2014 08:43:26 GMT

It works exactly like I wanted.

Thanks a lot!