Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
r_vdbraak
Contributor III
Contributor III

Add average to graph

Hi,

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.

Thanks,

Richard

1 Solution

Accepted Solutions
rajat2392
Partner - Creator III
Partner - Creator III

=count({$<Resultaat={'Gepakt'}>}Resultaat)/count({$<Resultaat={'Gepakt', 'Gemist'}>}Resultaat)

with this you are limiting your result to one company only...you have dimension as company...so just write this expression

=count(Resultaat)/count(TOTAL Resultaat)

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.

View solution in original post

9 Replies
sujeetsingh
Master III
Master III

Just use as

sum({1}Field1)/count({1}Field1)

sujeetsingh
Master III
Master III

This will give you the overall Avg of the data

Not applicable

Hi Richard,

you could add the average from the Graph Properties->Expression-> Trendlines-> click on Average.

I hope this help you.

average.png

r_vdbraak
Contributor III
Contributor III
Author

Sujeetsingh,

Thanks for thinking with me.

When I try your answer my own results are not shown.

I use the expression:

=count({$<Resultaat={'Gepakt'}>}Resultaat)/count({$<Resultaat={'Gepakt', 'Gemist'}>}Resultaat)

Gr. Richard

ThornOfCrowns
Specialist II
Specialist II

Sometimes the simple answer is the best.

r_vdbraak
Contributor III
Contributor III
Author

Guiseppe,

Thanks for thinking with me.

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.

Gr. Richard

r_vdbraak
Contributor III
Contributor III
Author

When it does what you want, Yes.

rajat2392
Partner - Creator III
Partner - Creator III

=count({$<Resultaat={'Gepakt'}>}Resultaat)/count({$<Resultaat={'Gepakt', 'Gemist'}>}Resultaat)

with this you are limiting your result to one company only...you have dimension as company...so just write this expression

=count(Resultaat)/count(TOTAL Resultaat)

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.

arjunkrishnan
Partner - Creator II
Partner - Creator II

Hai frd..

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