Colour by expression on single colours

[vicobi123]

I have a line chart with two expressions, is there a way I can colour each expression with two different single colours?

[tajmohamed30]

on the expression background color you can try like

=if(sum(Sales)>=5000,Green(),if(sum(Sales)<=4999,Red()))

[vicobi123]

Hi Taj, that's not what i want to do. I have two expression:

1. Sum([Home Yellow]) + Sum([Away Yellow])

2. Sum([Home Red])+Sum([Away Red])

I want to colour the first expression as yellow and second expression as red. Now i've tried

if((Sum([Home Yellow]) + Sum([Away Yellow])), rgb (255,0,0), if((Sum([Home Red])+Sum([Away Red])),rgb (0,255,0)))

I've also tried

if((Sum([Home Yellow]) + Sum([Away Yellow]))=(Sum([Home Yellow]) + Sum([Away Yellow])),yellow(),if((Sum([Home Red])+Sum([Away Red]))<=(Sum([Home Red])+Sum([Away Red])),Red()))

They both don't work.

Regards,

Vic

[tajmohamed30]

on the properties>colors tab, you can change colour 1 and 2 and also you have the option to define rgb values

[micheledenardi]

On expression background set:

rgb (255,0,0) //(for Sum([Home Yellow]) + Sum([Away Yellow]) expression)

rgb (0,255,0) //(for Sum([Home Red])+Sum([Away Red]) expression )

[vicobi123]

This is on Qliksense btw

[vicobi123]

This Qlikview, i'm talking about the ability to do this on Qliksense

[micheledenardi]

Create a dimension using valuelist(),

Valuelist('Home Yellow + Away Yellow','Home Red + Away Red')

then create 1 expression:

1. if(rowno()=1,

          Sum([Home Yellow]) + Sum([Away Yellow]),

          Sum([Home Red])+Sum([Away Red])

     )

then under "Aspect->Colors" use "color by expression" and write:

if(rowno()=1,rgb (255,0,0),rgb (0,255,0))

[vicobi123]

Hi, it's a line chart and the only dimension is 'Months'. How will creating a valuelist dimension solve this?

[tajmohamed30]

Expression for custom color for measures

Custom color by expression for two different expressions