This content has been marked as final. Show 2 replies
I have a line graph with two dimensions X Axis - (Date), Line - (Business) and an expression the Y-Axis is (Count of Widgets).
I use set analysis in the expression so that no matter what Business or Date is selected the chart shows all values.
Expression (Named: Number of Widgets):
Date has three values
Business has three values for each Date,
R, G, B
|Date||Business||Count of Widgets|
When coloring the Expression, I have a different color for every business (R= Red, B=Blue,, G=Green) using the RGB logic The expression I use is:
I want to be able to keep the coloring even if there is a selection on the Date field. But as of right now with the selection of a date, the other dates are shown as grey. Please note the image below does not match exactly the example above, it is a more complex version but the concept holds true..
Any help would be greatly appreciated. And as an FYI, I only have a personal edition so I cannot open other people's QVWs.