QlikView - Average of different columns

[#1]

I am a complete newbie on QlikView, and have managed to figure out bits and pieces, but this is leaving me stumped.

In Excel I find it easy to calculate the average of 3 different columns, but how to create a graph from these averages in Qlikview is eluding me. I have managed to get the graph to show the overall average of the three columns, but I want it to show these averages by supplier along the x axis. I have tried simply adding 'Supplier' as a dimension, but it then says "No data to show". I've tried browsing previous forum threads, but nothing seems to answer my specific question.

I've attached a screenshot of my dashboard - the bottom left graph is the one I'm trying to create, the top right table shows the data I'm working from.

Any help will be very greatly appreciated!

[sunny_talwar]

What is the expression you are using?

[#3]

In order to get the average of all 3 I'm just using the below, but it's obviously completely wrong. I've been fine with averages in the past, as they've only been for a single column, therefore, avg(column) has always worked fine

avg(Month1Perf)&(Month2Perf)&(Month3Perf)

[sunny_talwar · Accepted solution]

May be try this:

RangeAvg(Month1Perf, Month2Perf, Month3Perf)

[#5]

That works! Thanks I knew it would be something simple I was missing.

[#6]

Hi

you can find the average by using

(Column(1)+Column(2)+Column(3))/3