# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for
Did you mean:
Partner

## How to exclude a NULL Dimension with a Value

Hey there,

I'm having a Dataset, where the Sum can be >0, but the Dimension Value is NULL.

It's not a big problem, but in a line chart for example, the Y-Axis Scaling is based on that sum.

Let me show you 2 Screenshots:

Table with the NULL Dimension and ValueLine Chart Y-Axis till this Value

So as you can see, there is this Dimension '-' and it's SUM = 11k

The Linechart Y-Axis is till 12k, so just because of this NULL value, which can't be displayed either way.

So my Question. How can I exclude this Value? There is no such Option as 'Supress Zero/NULL Values.No supress Option

Thank you so much in advance for your time and effort 🙂

Labels (1)
• ### Qlik Sense

1 Solution

Accepted Solutions
Contributor III

Hi

in expression

sum({<Date-={''}>}stuckzahl) =>it eliminates null values in Date.

7 Replies
MVP

Can you try this expression

`Sum({<Date = {"*"}>}[Stuckzahl])`
Partner
Author

Works like a charm!
If you could give me a short explanation oh what just happened, I'd be super happy!
Or give me a link to th explanantion of this "*" and so on.
Thanks a lot mate!

MVP

All the set analysis do is to include all the Date where the Date is not null

Date = {"*"}

Partner
Author

Hey there. I have a Problem now.

If i want so select a Date range, nothing happens...

Is there a way to allow selections and concurrently exclude the NULL values?

Date rangeSelection but nothing updates

Contributor III

Hi

in expression

sum({<Date-={''}>}stuckzahl) =>it eliminates null values in Date.

Partner
Author

Awesome! Excactly what I needed.

Can you give me a Link or something where I can lookup this Stuff with '-=' and '' and so on? Can't find it anywhere.

Partner

Hi @sunny_talwar and all - is there a difference between

`{<Date = {"*"}>}`

and

`{<Date = {P()}>}`

?