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(),



      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!