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: 
wanyunyang
Creator III
Creator III

don't show null measure values

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!

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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

KomalT
Contributor
Contributor

Hi Sunny,

I require your help in below condition.

KomalT_1-1602754720253.png

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.