topic Excluding Nulls from expression in QlikView

Excluding Nulls from expression

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

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

Anonymous — Tue, 04 Jul 2017 14:47:28 GMT

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

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

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

effinty2112 — Tue, 04 Jul 2017 14:50:49 GMT

Hi Kathryn,

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

Cheers

Andrew

tajmohamed30 — Tue, 04 Jul 2017 15:02:15 GMT

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