Adding customized color to lines in Line graph

[berryandcherry6]

Hi,

I have a graph with

Dimension: Month

Expresion : count({<DateType = {invitation} >}invitation_id)

                      count({<DateType = {completion} >}completion)

                     count({<DateType = {accesed} >}accesed)

Its taking default colors, i need to add my own colors/add customized color. How to do this?

You can find the Qvf file attached below

Please help me.

Regards

[Chanty4u]

try

if(count({<DateType = {invitation} >}invitation_id),Red(),

                      if(count({<DateType = {completion} >}completion),green(),

                 if(    count({<DateType = {accesed} >}accesed),yellow(),blue())))

[ecolomer]

See this image:

[berryandcherry6]

Thanks,

I have three expression, you have suggested to use one expression. Should i replace given expression in all three expression of my or where should i put this?

[berryandcherry6]

Thnaks for reply,

Your condition Put color based on value of y axis in if condition.

But my Counts differs everyday and counts are dynamic.So

Line color of Invitation,completion and accessed  should be static  irrespect of counts.

[ecolomer]

You can assign colour for each dimension or expression, and you can write a complete expression to select the colour result in this expressions

[ecolomer]

If you upload an example with your data, can explain better

[berryandcherry6]

Hi,

Please Check attached Qvf file

[ecolomer]

See this images (I'm sorry because my QV & QS are in Spanish version)

[berryandcherry6]

Hi,

Is this below expression i should give in By expression box

if(Sum({<Year={2014}>} Inv),Red(),

if(Sum({<Year={2015}>} Inv),green(),

if( Sum({<Year={2014}>} Crs),yellow(),blue())))

If i give like this Every line will be blue.