Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Average value of orders

Hi all together,

I try to achieve a diagram, that looks like this.

AVG.JPG

I already got the diagramm, but what is missing is the average value. My dimension is "Projektleiter" and my measure is "Auftragswert", which is the value of a "Projekt". I tried to achieve a structure like seen above with the following formula:

((sum(Auftragswert))/Count(Projekt))*Count(distinct Projektleiter)

My graph looks like this:

Graph.JPG

Is there any easy way to get the average amount as seen above?

Thanks for the help.

Regards,

Tom Müller

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

You could try it with:

((sum(total Auftragswert))/Count(total Projekt))*Count(distinct total Projektleiter)

- Marcus

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

You could try it with:

((sum(total Auftragswert))/Count(total Projekt))*Count(distinct total Projektleiter)

- Marcus

View solution in original post

Highlighted
Creator
Creator

Thanks for the reply, now my graph looks like expected, but the value of the AVG function is too high.

Graph.JPG

Do you have an idea, what could be the reason? I am wondering myself whether it is necessary to incloude the Count (total Projekt), may there be another possibilty? I believe the mistakes is caused by this part.

Highlighted
Master II
Master II

hi,

would be able to share the mock, so that we can check. tks

Highlighted
Creator
Creator

Thank you, I got it by myself. ((sum(total Auftragswert))/Count(distinct total Projektleiter) works.