Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Average per product compared to total avarege

I have a set of data like this (in orange)

Udklip.JPG

The average per product is in blue and know I like to calculate the 'average per product' devided by the 'total avere' and put the numbers (those in green) in a bar chart.

Example Product A:

The average is 3.5 ((5+2) / 2 ) and compared to the total average i get 92 % (3.5 / 3.8 * 100)

Example Product C:

The average is 5 ((6+4) / 2 ) and compared to the total average i get 132 % (5 / 3.8 * 100)

How do I do that?

1 Solution

Accepted Solutions
MVP
MVP

Re: Average per product compared to total avarege

This?

Capture.PNG

Expression 1: =Avg(Val)

Expression 2: =Avg(Val)/Avg(TOTAL Val)

2 Replies
MVP
MVP

Re: Average per product compared to total avarege

This?

Capture.PNG

Expression 1: =Avg(Val)

Expression 2: =Avg(Val)/Avg(TOTAL Val)

Not applicable

Re: Average per product compared to total avarege

Thanks - I wasn't aware of the 'Total function':

=Avg(Val)/Avg(TOTAL Val)

Community Browser