topic Re: Surpress Null in Set Analysis in text object in QlikView

Surpress Null in Set Analysis in text object

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Surpress Null in Set Analysis in text object

swuehl — Fri, 15 Apr 2016 16:35:22 GMT

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.

Re: Surpress Null in Set Analysis in text object

sunny_talwar — Fri, 15 Apr 2016 16:36:13 GMT

May be this:

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