Exclude Null measure in table

Noor51 — Tue, 16 Sep 2025 21:13:44 GMT

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.

Here how it looks now.

Re: Exclude Null measure in table

QFabian — Tue, 16 Sep 2025 21:18:37 GMT

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() :

and then the type straight table chart looks like this :

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