Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Surpress Null in Set Analysis in text object

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

1 Solution

Accepted Solutions
sunny_talwar

May be this:

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

May be this:

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