topic Re: chart with multiple line , how to make it multiple color ? in QlikView

chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 03:32:35 GMT

Hi All

I have a chart with multiple line . the color of each line same color , how to make it diff color ?

i will enclosed my sample QV doc in my next post.

Paul

Re: chart with multiple line , how to make it multiple color ?

ajsjoshua — Mon, 01 Feb 2016 05:19:23 GMT

Hi paul,

Prop->colors->

change the colors in that.

Regards,

Joshua

Re: chart with multiple line , how to make it multiple color ?

kkkumar82 — Mon, 01 Feb 2016 05:49:57 GMT

Hi,

goto the chart properties -> colors tab -> multicolored.

I have seen your graph, there is only one expression in it , you cannot different lines.

Thanks

Kiran

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 06:05:57 GMT

Hi Krian

Thank you for your sharing . I am

Not able to tick on multiple Color box as it is disable.

Yes I have only one expression , but the GROUP field have 10 line . I place this field as diamendion .

Any work around ?

Paul

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

kkkumar82 — Mon, 01 Feb 2016 06:27:36 GMT

Hi Paul,

The second dimension doesn't have any values I think that is the reason it is not showing up values(Lines).

Can you recheck your expression for the second dimension.

Thanks

Kiran Kumar

Re: chart with multiple line , how to make it multiple color ?

jyothish8807 — Mon, 01 Feb 2016 06:34:55 GMT

Hi Paul,

I this case you have to write an expression to set the color for each 10 line.

In dimension:

1.click on the + sign of group.

2. If(Group='ABC',rgb(10,1,21),if(Group='BCD',rgb(1,2,3)))

You can try like this.

Regards

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 07:26:57 GMT

Hi Sir

I try your script but the Color never change.

My field name GROUP_CLASS , label = G1 , I insert your example with my field name not working .

Paul

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

rajeshforqlikvi — Mon, 01 Feb 2016 07:41:20 GMT

Hi ,

for bar chart left axis is there and for the line chart right axis is there.

do you have any relation between them if yes then it will be easy to write the condition for background color.

Regards

Rajesh Kumar

Re: chart with multiple line , how to make it multiple color ?

jyothish8807 — Mon, 01 Feb 2016 07:58:44 GMT

Hi Paul,

Can you share a sample app ? That will be helpful to understand.

Regards

Jyothish KC

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 08:06:33 GMT

Hi KC

I Have enclosed the QV sample file at 2 posting.

Paul

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

marcus_sommer — Mon, 01 Feb 2016 08:12:40 GMT

Have you already looked here: Colors in charts?

- Marcus

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 08:21:34 GMT

Not yet , look like very nice article , will read thru

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

jyothish8807 — Mon, 01 Feb 2016 08:42:55 GMT

Hi Paul,

Just remove the condition you have in background color for expression:

Then you will have multi color

Regards

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 08:50:57 GMT

Hi KC

Thank now all line have Color , I have tick expression as legend , but the legend not display out why ?

Paul

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

jyothish8807 — Mon, 01 Feb 2016 09:12:31 GMT

Hi Paul,

Legends are present in your chart, yo need to press shift+ctrl and drag the legend bar a little up.

Regards

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 10:07:10 GMT

Thank it work now

Sent from my iPhone

Re: chart with multiple line , how to make it multiple color ?

jyothish8807 — Mon, 01 Feb 2016 10:32:53 GMT

Hi Paul,

Could you please close the thread by marking the correct answer

Regards

Re: chart with multiple line , how to make it multiple color ?

paulyeo11 — Mon, 01 Feb 2016 12:47:58 GMT

Done !

Sent from my iPhone