Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are you looking for this in the bar graph or the pivot table?
Hi Sunny,
I wanted to show this in bar graph.
You dimension is Month in the chart, you want the overall average by Month?
Thank you for your help Sunny. However, I wanted to show avg for each month in graph.
Please attach qvw with result.
Thanks!
So you will see 5 bars with 80.17 for Month 1, 126.29 for Month 2 and so on....?
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.
Try this:
=Avg(Aggr(Sum(Field4)/Sum(Field3), Month, Field1))
WOW!! Thank you so much sunny. You made my day
This forum is incredible!!!!
Hahahaha I am glad we were able to resolve your issue