4 Replies Latest reply: Oct 22, 2018 4:44 AM by patrice salem RSS

    Hide measure legend combined with qsVarialble

    patrice salem

      Hello

       

      I'm using QS Variable to let users choose wheather they want to display quarter, semester sales, targeted sales...

      ScreenShot124.jpg

      Everything works great using the Pick function in the measure Expression and a if fucntion for displaying or not the label:

       

      Example for the Target 2018 measure

       

      Expression :

      pick (vAffichageTarget,

      Sum([2018 Target]),0

      )

       

      Label

      = if ($(vAffichageTarget)>0,'Target '& year(now()),null())

       

      If I click on "Without Target 2018", the target 2018 bar disappears and the label shows the colour and "-" next to it.

      ScreenShot125.jpg

       

      I would like the legend to disappear (I have unchecked "show null values" from the add-ons options) AND I would also like to remove the empty space previously taken by the Target 2018 bar (to make the chart less wider).

       

      Any idea ?

       

      Thanks

      pat