Need help with coloring expression for line graph

[#1]

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):

=sum({<Business=,Date=>}Count_of_Widgets)

Date has three values

1/1/2016, 2/1/2016,3/1/2016

Business has three values for each Date,

R, G, B

Date	Business	Count of Widgets
1/1/2016	R	1
1/1/2016	B	2
1/1/2016	G	3
2/1/2016	R	4
2/1/2016	B	5
2/1/2016	G	6
3/1/2016	R	7
3/1/2016	B	8
3/1/2016	B	9

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:

IF(Business='R', RGB(255,0,0)

IF(Business='G',RGB(0,255,0)

IF(Business='B',RGB(0,0,255)

RGB(230,230,230)))

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.

[sunny_talwar · Accepted solution]

Try this:

IF(Only({<Business=,Date=>}Business)='R', RGB(255,0,0)

IF(Only({<Business=,Date=>}Business)='G',RGB(0,255,0)

IF(Only({<Business=,Date=>}Business)='B',RGB(0,0,255)

RGB(230,230,230)))

[#3]

That was it, thanks!!!