Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need help with coloring expression for line graph

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

DateBusinessCount of Widgets
1/1/2016R1
1/1/2016B2
1/1/2016G3
2/1/2016R4
2/1/2016B5
2/1/2016G6
3/1/2016R7
3/1/2016B8
3/1/2016B9

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..

Capture.JPG

Any help would be greatly appreciated. And as an FYI, I only have a personal edition so I cannot open other people's QVWs.

Tags (1)
1 Solution

Accepted Solutions

Re: Need help with coloring expression for line graph

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

2 Replies

Re: Need help with coloring expression for line graph

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

Not applicable

Re: Need help with coloring expression for line graph

That was it, thanks!!!

Community Browser