I have a line chart showing a KPI across years. It uses a full load of data from 5 DHBs. There is one line for all DHBs using the set expression
and another line using
The chart works as expected, but I'd like to change its colours. At the moment the "all DHBs" line is pale blue and the A line is pale red - these are automatic colours.
If I use custom colours by expression, something like
if([DRG] = 'A', red(), RGB(179,179,179))
which worked before I used set expressions, both lines are grey.
Is this because DHB 'A' is included in the 'All DHBs' set?
Is there anything I can do about it?
I assume, You may use Color which already built in Color Tab from properties of that chart? There you have to customize the Color Code Color functions ‒ QlikView
Sorry for the lack of clarity: I want to colour the 'A' line red, and either leave the 'All' line grey or force it to be grey.
That way the coloured selection stands out against the lighter one.
I don't think that Qlik Sense Desktop has that method; it looks very clever...
We do have the ability to specify colours, but they aren't working (using the method I've used in the past).
I apologies, That's my fault
Will you able to share the screen, and can you tell us whether where we need to change i mean which line that may helps to understand rather than Functional
Let's see whether I can do this:
First, I have a simple chart. Colours are selected automatically:
Then I tried to colour the lines: if the DHB is A, use a deeper red, otherwise grey:
The expression is
if(DHB = 'A',RGB(178,36,36),RGB(179,179,179))
Sadly, I got this:
so my expression didn't work.
I have used
if(DHB = 'B' , argb(125,0,0,255) ,
if(DHB = 'C', argb(125,0,255,0) ,
if(DHB = 'D', argb(125,255,0,0) ,
if(DHB = 'E', ARGB(125,0,255,255),
if(DHB = 'A',RGB(178,36,36))))))
and the result was
so I know the method works - bit I think it might be tripping up when DHB 'A' is part of the whole.
May be data points are more for DHB - A. Can you check over there? Because of color the line won't effect. And We really don't know which is for which color. The Red color is for A? I am sorry to question you?