Discussion Board for collaboration on QlikView Layout & Visualizations.
In my line graph I have the dimensions WeekYear and Company
I have one expression that is a calculated result.
I want to add the average results of all companys to the graph.
How can I do this.
Go to Solution.
with this you are limiting your result to one company only...you have dimension as company...so just write this expression
so when the dimension will be Company, for each Company it will give the average of each Company...when the dimension is Week or Year, the average will be for each Week or Year respectively.
Just use as
This will give you the overall Avg of the data
you could add the average from the Graph Properties->Expression-> Trendlines-> click on Average.
I hope this help you.
Thanks for thinking with me.
When I try your answer my own results are not shown.
I use the expression:
Sometimes the simple answer is the best.
When I use this solution I got a straight line for every Company.
What I want is one line for all Companies together that shows the average result per week.
When it does what you want, Yes.
Calculate Your Avg In Reference line in Chart...
Presentation Tab->Reference line -> Substitute Ur Formula In Expression and Lable -> U Should Show The Avg In Line In Your Chart....