Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gal_polak
Creator
Creator

Qlik sense line chart - hide dimension null values

Hi,

I've created a line chart with two dimensions:

1. for dates - x axis.

2. for properties - different line per property.

i'm using the following "if" statement in the properties dimension:

=if([Property Name]='Seniority',[Property Value])

because i would like to get only property values that are related to the specific property name,

but as you can see below what happens is that i have a third line (gray) for total performance of all the others:

 

line chart.png2018-05-28_10-19-30.png

is there a way to hide the gray line?

i would like to avoid adding statements to the measure (total performance) .

1 Solution

Accepted Solutions
gal_polak
Creator
Creator
Author

Hi guys,

thx for the comments,

so the right answer was to disable the "Continuous" auto  in the X-axis

and then I was able to uncheck the "Include null values".

View solution in original post

3 Replies
thkarner
Partner - Creator III
Partner - Creator III

Hi, try the following:

Let the dimensions as they are, first date, second Property name (without if).

The measure you should define with set analysis like:

SUM( {<[Seniority]={'Senior', 'Junior'}>}  [Property Value])

This should only show values where Seniority is equal Senior or Junior.

BR Thomas

NZFei
Partner - Specialist
Partner - Specialist

Uncheck "Include null values" in the second dimension settings.

gal_polak
Creator
Creator
Author

Hi guys,

thx for the comments,

so the right answer was to disable the "Continuous" auto  in the X-axis

and then I was able to uncheck the "Include null values".