topic Re: Changing line color in Line Graph in QlikView

Changing line color in Line Graph

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am struggling to change the color of lines in my line graph with 3 lines. I know this can be changed using "colors by expression" option but not sure how to write an expression.

The data in my line chart looks like below (example) -

Dates aPlanned aComplete aReview

12/09/2016 10 8 5

13/09/2016 10 9 6

14/09/2016 11 10 6

I would like to give Black color to Planned and Green to complete (just an example). Can anyone please help me here. Thanks

Sonal

Re: Changing line color in Line Graph

saimahasan — Mon, 12 Sep 2016 17:45:22 GMT

Is this whats you are willing to achieve??

Re: Changing line color in Line Graph

kumarkp412 — Mon, 12 Sep 2016 17:55:31 GMT

Hi Sonal,

Can you view the below link shared by Posted by amz

Line Chart tricks: Displaying what's important

I hope it helps you.

Thanks

Kumar

Re: Changing line color in Line Graph

MindaugasBacius — Mon, 12 Sep 2016 18:04:35 GMT

There is how to can accomplish your needs:

Re: Changing line color in Line Graph

MarcoWedel — Mon, 12 Sep 2016 23:44:14 GMT

please post a sample application to demonstrate with

thanks

regards

Marco

Re: Changing line color in Line Graph

Tue, 13 Sep 2016 07:04:33 GMT

Hello Saima,

Thanks, this looks helpful. How did you manage to get green and black line colors? Please note that i am using QlikSense Desktop and need expression to change colors.

Re: Changing line color in Line Graph

Tue, 13 Sep 2016 07:05:43 GMT

Is this Qliksense Desktop? Sorry i am too new to this.

Re: Changing line color in Line Graph

Tue, 13 Sep 2016 07:06:22 GMT

IS this Qliksense Desktop? I don't see this option in my tool. Can you please help me locate? Thanks

Re: Changing line color in Line Graph

kumarkp412 — Tue, 13 Sep 2016 20:29:15 GMT

Hi Sonal,

This is not for Qlik sense . It is for Qlikview.

Line chart properties:

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Visualizations/LineChart/line-chart-properties-panel.htm

Hope this could help you.

Thanks

Kumar KVP

Re: Changing line color in Line Graph

MK9885 — Tue, 13 Sep 2016 20:52:39 GMT

Color by expression for two different measures in a Combo Chart

For Qlik Sense the color coding is limited and you can only edit colors by

chart Properties>Colors and Legend>Custom Color>By Expression.

Re: Changing line color in Line Graph

Wed, 14 Sep 2016 06:51:23 GMT

Yes i am aware, but i don't know how to write expression in this case. That's exactly the problem i am facing.