How to exclude a selection from a total but yet still be selectable

[#1]

Hello Qlik Community,

I am hoping someone can help me with my problem that I am facing.

Basically, I have three Fields which are lets just say: Football Team, Goals Scored, Salary

I then have to firstly get the MEDIAN for both Goals Scored and Salary. For example I make the following selection:

Football Team = Manchester United

Goals Scored = Shows All (5,14,7,4,2)

Salary = Shows All (100,120,80,50,70)

The MEDIAN for Goals Scored would be 5 and the MEDIAN for Salary would be 80

I then have a table that displays FOOTBALL PLAYER NAMES along with thier Goals Scored and Salary. I then have a fourth column that puts the players into certain categories based on wheather there Goals Scored and Salary is higher or lower than the Median. For example:

Name:Wayne Rooney, Goals Scored: 14, Salary: 120

As his Goals Scored and Salary are above the Median which is 5 and 80 this would put Wayne Rooney in the Super Class Field

Now the problem I am facing is that if a user now selects to view Wayne Rooney and Rio Ferdinand, the Median for both Goals Scored and Salary have now changed based on my selection.

I do not want this to happen, I want the MEDIAN to remain calculated for the total field selection for 'Football Team', 'Goals Scored' and 'Salary'

For example:

Name: Rio Ferdinand, Goals Scored 2, Salary 70

As Rio Ferdinand has only scored 2 goals this is below the 5 goals median but and his salary is 70 which is also below the salary median of 80 which would class Rio Ferdinand in the 'Paying Too Much Field'

But if i just select Rio Ferdinand and now he is the total category he automatically becomes a Super Class Field category because his Goals scored and salary become the Median.

Basically I need to lock the MEDIAN to the selection of Football Team, Goals Scored and Salary only

I hope this makes sense and someone can assist me

Many Thanks in advance

Kind Regards

Yusuf Khan

[#2 · Accepted solution]

Use set analysis to overrule your player's selection: Median({<[Player Name] =>} Salary)

[#3]

wow that was a fast response and the correct one. Helped me loads, thank you very much Ducati 888 SP5