1 Reply Latest reply: Nov 11, 2011 3:27 AM by Kiran Rokkam RSS

    Conditions on expression


      I have a client solution where they have a explaining text as an expression, set as Text as popup on a Dashboard/ Gauge Chart. Is it possible to add a condition to this expression so that it's just shown when RR_Business = Insurance?


      I had solved this in version 10 and 11, but as the client is on version 9 I have to do it differently...



      =' ' & 'Helptext'





      Senior Business Discovery Manager at Advectas AB

        • Re: Conditions on expression

          The easiest way would be changing the expression to null or helptext dynamically if Only(RR_Business) = 'Insurance'. Eventhough the popout comes it comes as null.


          If you want to disable the textas popout dynamically, probably you need to trigger the macro when field selection is changed:


          set chart = ActiveDocument.GetSheetObject("CH01")
          set Prop = chart.GetProperties 
          Prop.ChartProperties.ShowValueInPopup(0) = true 'or false
          chart.SetProperties Prop