Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
ajaysingh29
Contributor III
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.

query.PNG

I wanted to display highlighted avg for every months.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

Capture.PNG

View solution in original post

9 Replies
sunny_talwar

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

ajaysingh29
Contributor III
Contributor III
Author

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?

Capture.PNG

ajaysingh29
Contributor III
Contributor III
Author

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

query1.PNG

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
Contributor III
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.

kindly reply with updated qvw.

Thank you.

sunny_talwar

Try this:

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

Capture.PNG

View solution in original post

ajaysingh29
Contributor III
Contributor III
Author

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