Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
Not applicable

QlikView - Average of different columns

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!

1 Solution

Accepted Solutions
Highlighted

Re: QlikView - Average of different columns

May be try this:

RangeAvg(Month1Perf, Month2Perf, Month3Perf)

View solution in original post

5 Replies
Highlighted

Re: QlikView - Average of different columns

What is the expression you are using?

Highlighted
Not applicable

Re: QlikView - Average of different columns

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)

Highlighted

Re: QlikView - Average of different columns

May be try this:

RangeAvg(Month1Perf, Month2Perf, Month3Perf)

View solution in original post

Highlighted
Not applicable

Re: QlikView - Average of different columns

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

Highlighted
Not applicable

Re: QlikView - Average of different columns

Hi

you can find the average by using

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

New.jpg