don't show null measure values

[wanyunyang]

My Qlik Sense straight table is like:

Order  Item    SUM(sales)

1            A          300

1            B            -

I want to show only the records with SUM(sales). In this case:

Order  Item    SUM(sales)

1            A          300

Since SUM(sales) is measure, so there is no "show null values" box. How should I write the functions for Order and Item dimensions?

Thanks for help!

[sunny_talwar · Accepted solution]

Uncheck 'Include zero values' under Data Handling -> Add-Ons

[KomalT]

Hi Sunny,

I require your help in below condition.

I applied condition for Mismatch vale and No.of instances is below.

For No.of instances: if(Count(If(MISMATCH_VAL>10000000,MISMATCH_VAL))>0,Count(If(MISMATCH_VAL>10000000,MISMATCH_VAL)))

for mismatch value: if(Sum(If(MISMATCH_VAL>10000000,MISMATCH_VAL))>0,Sum(If(MISMATCH_VAL>10000000,MISMATCH_VAL)))

even I have untick include null values still it is displaying null value data. please help.