How to display Avg from calculated sum in graphs

[ajaysingh29]

Hi All,

I am new to qlikview & need your help.  I have data set in which I wanted to show Avg of sum in chart.

I have attached QVW. following image may help you to understand my concern.

I wanted to display highlighted avg for every months.

[sunny_talwar]

Are you looking for this in the bar graph or the pivot table?

[ajaysingh29]

Hi Sunny,

I wanted to show this in bar graph.

[sunny_talwar]

You dimension is Month in the chart, you want the overall average by Month?

[ajaysingh29]

Thank you for your help Sunny.  However, I wanted to show avg for each month in graph.

Please attach qvw with result.

Thanks!

[sunny_talwar]

So you will see 5 bars with 80.17 for Month 1, 126.29 for Month 2 and so on....?

[ajaysingh29]

Yes, you are correct.

For month 1 it should show 80.17, 2=>126.29, 3=>78.40,4=>111.00,5=>91.50.

kindly reply with updated qvw.

Thank you.

[sunny_talwar · Accepted solution]

Try this:

=Avg(Aggr(Sum(Field4)/Sum(Field3), Month, Field1))

[ajaysingh29]

WOW!! Thank you so much sunny. You made my day

This forum is incredible!!!!

[sunny_talwar]

Hahahaha I am glad we were able to resolve your issue