Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Excluding Nulls from expression

How can i go about excluding nulls from an expression? I don't want to see any data in my line graph for when there is no data in the vendor field.

I looked online and managed to find this expression:

Sum({$<Vendor-={$(vVendorNoNull)}>}Values)

Where vVendorNoNull = Concat( DISTINCT TOTAL If(IsNull(Vendor), Chr(39) & Vendor & Chr(39)), ', ')

Which i was expecting to work but resulted in my chart saying that the allocated memory was exceeded. Any other ideas?

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable

Sum({$<Vendor={"*"}>} Values)

or

Sum({$<Vendor=P(Vendor) >} Values)

or

Sum({$<Vendor*={"*"}>} Values)

View solution in original post

3 Replies
Anonymous
Not applicable

Sum({$<Vendor={"*"}>} Values)

or

Sum({$<Vendor=P(Vendor) >} Values)

or

Sum({$<Vendor*={"*"}>} Values)

effinty2112
Master
Master

Hi Kathryn,

                         Have you checked the Suppress When Value Is Null box in the Dimension tab of your chart?

Cheers

Andrew

tajmohamed30
Creator III
Creator III

try like this in the expression =if(Sales>0,Sales)