Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
gal_polak
New Contributor III

Line chart set ranges to disregard null value in dimension with condition

Hi,

I'm working on a line chart and i notice that in case i add set analysis to the dimension i cannot hide NULL values.

for example: 

I have a dimension Date that i added set analysis to it in order to present values only from this year:

=if(year(Date)=2019 and Date<=today(),Date)

but when i do that the table results with one row of NULL values 

2019-08-12_12-12-33.png

and in the line chart dimension there is not checkbox to hide the NULL values.

 

this later effect the Y axis ranges, 

when set to automatic it take into account the value of the NULL row. 

2019-08-12_12-12-45.png

 

Q: how can i hide the null row when using set analysis in the dimension? 

 

1 Solution

Accepted Solutions
gal_polak
New Contributor III

Re: Line chart set ranges to disregard null value in dimension with condition

I think i found a work around..
by creating a table and un-checking the "Include null values" 

and after convert it to line chart.. 

it works in a simple case.. i hope it will work in other places i need it.

 

but if some one do know how to bring back the check box in the line chart i will be more then happy!

7 Replies

Re: Line chart set ranges to disregard null value in dimension with condition

Have you tried unchecking 'Include null values' under your dimension?

image.png

gal_polak
New Contributor III

Re: Line chart set ranges to disregard null value in dimension with condition

That's what i'm saying that the checkbox is not there 😞

2019-08-12_16-29-18.png

Re: Line chart set ranges to disregard null value in dimension with condition

Check version of Qlik Sense are you using and which object?

gal_polak
New Contributor III

Re: Line chart set ranges to disregard null value in dimension with condition

I'm usign the lates version. 

and the line chart is not an extension, it is the one provided with the product

2019-08-12_16-51-00.png

 

maybe i'm missing something?

Re: Line chart set ranges to disregard null value in dimension with condition

I have the same version like yours, but I see that option under my dimension... I am not sure why you are not seeing it

image.png

gal_polak
New Contributor III

Re: Line chart set ranges to disregard null value in dimension with condition

😭i can't find anything that will explain this..

gal_polak
New Contributor III

Re: Line chart set ranges to disregard null value in dimension with condition

I think i found a work around..
by creating a table and un-checking the "Include null values" 

and after convert it to line chart.. 

it works in a simple case.. i hope it will work in other places i need it.

 

but if some one do know how to bring back the check box in the line chart i will be more then happy!