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