Exclude Null measure in table

[Noor51]

I have a qlik sense on prem table with 3 dimension and 3 measure. 3 dimension are NDC, Family, and Code. 3 measure are WAC, 340B, Special Price.

Here is the current set expression for special price Min({<GPO={'SP'}>}Price).

The only difference between each measure is what GPO = to. 

I want to exclude null from the special price measure, so that is only show dimension with values in special price.

Any help will be appreciate.

Here how I want it to look. 

NDC	Code	Family	WAC	340B	MHA
6332307720	951	Dextrose	$        2.00		$        1.30
6332307725	315	Accessories	$        6.00	$        1.00	$        1.30

Here how it looks now. 

NDC	Code	Family	WAC	340B	MHA
6332307720	951	Dextrose	$        2.00		$        1.30
6332307722	123	Sodium	$        4.00
6332307725	315	Accessories	$        6.00	$        1.00	$        1.30

[QFabian · Accepted solution]

i @Noor51 ,if i got it right, maybe one option is using conditional aggregation in expression, related to expression to consider :

i used this data as example :

Data:

Load * INLINE [

   NDC, Code,      Family, WAC, 340B, MHA

6332307720, 951,    Dextrose,   2,,          1.30

6332307722, 123,      Sodium,   4,,

6332307725, 315, Accessories,   6, 1.00, 1.30

];

and then, use these expressions, you should check if you need all of these conditions :

WAC : if(column(3) = '' or column(3) = 0 or isnull(column(3)), null(), sum(WAC))

340B : if(column(3) = '' or column(3) = 0 or isnull(column(3)), null(), sum([340B]))

MHA : if(sum(MHA) = '' or sum(MHA) = 0 or isnull(sum(MHA)), null(), sum(MHA))

column() refers to expressions from left to right, dimensions columns are not considered, here help about column() :

https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...

and then the type straight table chart looks like this :

so, you have to uncheck 'show zero values' and that is :