13 Replies Latest reply: Apr 22, 2014 5:02 PM by Saradhi Balla RSS

    Gauge variable color mapping

      Hi -

       

      I am trying to have different sections of a gauge in a pivot table display bars in different colors.  The attached screenshot shows 3 segments (We call a segment 'Tag Group' in the database).  And here is the code I am using to make the color variable:

       

      =IF([Tag Group]='All Households',            red(),

      IF([Tag Group]='Age Range',                 blue(),

      IF([Tag Group]='Consumer Creditworthiness', yellow(),

      IF([Tag Group]='Household Income',          green(),

      IF([Tag Group]='Make/Model',                blue(),

                                                   LightGray())))))

       

      But the displayed color is always coming out light gray.

       

      Does this function work in QV, and if so then what am I doing wrong?

       

      Thank you!