# Qlik Sense App Development

Contributor III

## Average of the excluded values

Hi everyone

This might be a simple question, but I can't seem to wrap my head around it. I have a table which can be simplified to the one below:

 Class Group Score A 1 10 A 2 20 A 3 50 B 4 80 B 5 85 B 6 40

I want the average score for my selections which I can get by using a simple Avg(Score). When I select Class = A and Group = 2 then my Avg(Score) will give me 20. How can I get the average for the scores in my selected Class (A), but for the Groups which are not in my Group selection (1 and 3). In other words, when I select the class and group in green in the table below, I want to get the average of the blue values (=(10+50)/2=30).

 Class Group Score A 1 10 A 2 20 A 3 50 B 4 80 B 5 85 B 6 40

Please let me know if anything is unclear.

Regards,

Mauritz

1 Solution

Accepted Solutions
Highlighted
Partner

## Re: Average of the excluded values

hi

this expressions will do the trick

Avg({<Group=e(Group)>}Score)

what it does , it disregards the selection in the group field and instead use the excluded values from the field

2 Replies
Highlighted
Partner

## Re: Average of the excluded values

hi

this expressions will do the trick

Avg({<Group=e(Group)>}Score)

what it does , it disregards the selection in the group field and instead use the excluded values from the field

Contributor III

## Re: Average of the excluded values

Thanks, works like a charm.

Regards,

Mauritz