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

    Qlik sense line chart - hide dimension null values

    Gal Polak



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