Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

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
MVP
MVP

Re: don't show null measure values

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

1 Reply
MVP
MVP

Re: don't show null measure values

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