# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for
Did you mean:
Contributor III

## How to display Avg from calculated sum in graphs

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.

1 Solution

Accepted Solutions
MVP

Try this:

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

9 Replies
MVP

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

Contributor III
Author

Hi Sunny,

I wanted to show this in bar graph.

MVP

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

Contributor III
Author

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

Thanks!

MVP

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

Contributor III
Author

Yes, you are correct.

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

Thank you.

MVP

Try this:

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

Contributor III
Author

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

This forum is incredible!!!!

MVP