Surpress Null in Set Analysis in text object

[#1]

Hi All

I have the following expression

sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}>} (PhaseTacklesPlayer))

I am calculation the number of tackles missed by a player in the 1st Phase

However, I have another dimension that is used to calculated the missed tackles for an individual player called TacklePlayerName. I use this dimension when looking at players individual stats

With the above expression I need to suppress Null Values from the TacklePlayerName Dimension

Any help will be greatly appreciated

Regards

[swuehl]

Not sure I've understood completely, try maybe

=sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}, [TacklePlayerName] = {"*"} >} (PhaseTacklesPlayer))

or upload a small sample QVW to better understand your setting.

[sunny_talwar · Accepted solution]

May be this:

Sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}, TacklePlayerName = {'*'}>} PhaseTacklesPlayer)