2 Replies Latest reply: Nov 23, 2012 6:46 AM by Alexander Yazykov RSS

    TextColor as result of info-calculation.

    Alexander Yazykov

      Hi everybody,

       

      i have a problem with colour of text in chart expression, equals within info-expression:

       

      for example:

       

      tab1:

      LOAD * inline

         [field1

          GOOD

          UNDEF_01

          UNDEF_02

          UNDEF_03

          UNDEF_04

          UNDEF_05

          UNDEF_06

          UNDEF_07];

       

      Info  LOAD * inline

         [field1,Color

          GOOD, '0'

          UNDEF_01,'10'

          UNDEF_02,'20'

          UNDEF_03,'30'

          UNDEF_04,'40'

          UNDEF_05,'50'

          UNDEF_06,'60'

          UNDEF_07,'70'];

       

      I set TextColor=Color(Info(field1)) in chart expression, but it`s not working.

      Who knows good way to this?

       

      Thanks!

        • Re: TextColor as result of info-calculation.
          Gysbert Wassenaar

          Info loads are for linking external information like documents or images.

           

          What you want can be done

           

          LOAD * inline

             [field1,Color

              GOOD, 0

              UNDEF_01,10

              UNDEF_02,20

              UNDEF_03,30

              UNDEF_04,40

              UNDEF_05,50

              UNDEF_06,60

              UNDEF_07,70];

           

          and set textcolor to color(Color), though you may want to use color(Color/10) instead since there's a limited number of predefined colors. Or the RGB function and fields for R,G and B values in your table.