9 Replies Latest reply: Feb 6, 2014 7:13 PM by walid hussein RSS

    Coloring dimension dispite using filters

      Hi everyone,

      I have a bar chart and two filters, the dimension is Date concatenated with Status Yes, No, NA. I colored the dimensions bars by using the (Substring) function to color by the Status Yes, No, or NA so I get three colors repeat for each date if concatenated with Yes (Green) If  No (Red) if NA (Blue). I fixed the view of the chart by using set analysis to return the count and empty string for the site number to ignore the selections. The problem is when the user uses the site number filter the colors change. I need the colors and the bars to not change even by using the site number filter. I will include the qvw in the attachments. Thanks and regards