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
Thanks for effort. The problem in using the alternate state is that the alternate state will affect the full chart. What I need is, to add effect on only one expression and not the whole chart. So, in this case Alternate state will not be so useful. Any other ideas??