Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
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 ValueTable with the NULL Dimension and ValueLine Chart Y-Axis till this 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 OptionNo supress Option

 

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

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: How to exclude a NULL Dimension with a Value

Hi

in expression

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

 

 

View solution in original post

6 Replies
Highlighted

Re: How to exclude a NULL Dimension with a Value

Can you try this expression

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

Re: How to exclude a NULL Dimension with a Value

Works like a charm! Heart
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!

Highlighted

Re: How to exclude a NULL Dimension with a Value

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

Date = {"*"}

Highlighted
Partner
Partner

Re: How to exclude a NULL Dimension with a Value

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 rangeDate rangeSelection but nothing updatesSelection but nothing updates

Highlighted
Contributor III
Contributor III

Re: How to exclude a NULL Dimension with a Value

Hi

in expression

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

 

 

View solution in original post

Highlighted
Partner
Partner

Re: How to exclude a NULL Dimension with a Value

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.