topic Re: How to display Avg from calculated sum in graphs in QlikView

How to display Avg from calculated sum in graphs

ajaysingh29 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 13 Dec 2016 12:22:54 GMT

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

ajaysingh29 — Tue, 13 Dec 2016 12:29:30 GMT

Hi Sunny,

I wanted to show this in bar graph.

sunny_talwar — Tue, 13 Dec 2016 15:06:07 GMT

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

ajaysingh29 — Wed, 14 Dec 2016 05:35:55 GMT

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 — Wed, 14 Dec 2016 09:47:35 GMT

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

ajaysingh29 — Wed, 14 Dec 2016 10:00:51 GMT

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 — Wed, 14 Dec 2016 10:03:45 GMT

Try this:

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

ajaysingh29 — Wed, 14 Dec 2016 10:16:24 GMT

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

This forum is incredible!!!!

sunny_talwar — Wed, 14 Dec 2016 10:19:04 GMT

Hahahaha I am glad we were able to resolve your issue