Qlik Community

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 
Search instead for 
Did you mean: 
joshuahirsch
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
sasis551
Contributor III
Contributor III

Hi

in expression

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

 

 

View solution in original post

7 Replies
sunny_talwar

Can you try this expression

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

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!

sunny_talwar

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

Date = {"*"}

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

sasis551
Contributor III
Contributor III

Hi

in expression

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

 

 

joshuahirsch
Partner
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.

Greg_Oliven
Partner
Partner

Hi @sunny_talwar and all - is there a difference between 

{<Date = {"*"}>}

and

{<Date = {P()}>}

 ?