Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Adding customized color to lines in Line graph

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

Tags (1)
11 Replies
sureshqv
Esteemed Contributor III

Re: Adding customized color to lines in Line graph

try

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

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

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

ecolomer
Honored Contributor II

Re: Adding customized color to lines in Line graph

See this image:

P_228880.png

berryandcherry6
Contributor II

Re: Adding customized color to lines in Line graph

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
Contributor II

Re: Adding customized color to lines in Line graph

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
Honored Contributor II

Re: Adding customized color to lines in Line graph

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
Honored Contributor II

Re: Adding customized color to lines in Line graph

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

berryandcherry6
Contributor II

Re: Adding customized color to lines in Line graph

Hi,

Please Check attached Qvf file

ecolomer
Honored Contributor II

Re: Adding customized color to lines in Line graph

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

P_1104115_1.png

P_1104115_2.png

berryandcherry6
Contributor II

Re: Adding customized color to lines in Line graph

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.

Community Browser