3 Replies Latest reply: May 29, 2018 3:25 AM by Gal Polak RSS

    Qlik sense line chart - hide dimension null values

    Gal Polak

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