Remove Null Values on Conditions

[Sake]

How to write conditional Null value expression for the table above, so that if a player doesn’t play any sports; keep the null value(-) in the table (in case of Jim –keep the null value). But if the Player plays one or more sport like in case of both Ron and Sam, remove the null values completely from the Sports Field. Qlik does have a check box option to exclude all null values from the “Sports” field but that will get rid of all null values: However, we want to keep null values for Jim in this case and get rid of null values for Ron and Sam. The reason why Jim has null value is because whoever is entering is either forgetting to enter sports for Jim or they don't play anything but we want to account for the player on the Table. We don’t want to see that Null Value(-) line for Ron and Sam for Aesthetics of the table. We want to get rid of the 4th and 6th row from the top that includes null value.

How to write the qlik expression or set analysis expression or any other solution to resolve this?

Thank you!

[Digvijay_Singh]

tried something like this below and it matches with your output but not sure if it would work with your real data - 

set NullInterpret='';

Sales:
Load * inline [
player, email, sports
Ron,ron@gmail.com,BaseBall
Ron,ron@gmail.com,FootBall
Ron,ron@gmail.com,
Sam,sam@gmail.com,Skating
Sam,sam@gmail.com,
Jim,jim@gmail.com,
];

for sports, used this calculated dimension - 

=if(aggr(distinct count(if(Coalesce(sports,0)<>0,1,0)),player)=1,'',sports)

and unchecked 'include null values' in the above calculated dimension.

Thanks,