Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gal_polak
New Contributor II

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
New Contributor II

Re: Qlik sense line chart - hide dimension null values

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".

3 Replies
thkarner
Contributor III

Re: Qlik sense line chart - hide dimension null values

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

xufei123
Valued Contributor

Re: Qlik sense line chart - hide dimension null values

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

gal_polak
New Contributor II

Re: Qlik sense line chart - hide dimension null values

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".