topic Re: Color coding in line chart in QlikView

Color coding in line chart

Anonymous — Thu, 31 May 2018 07:39:18 GMT

Hi, I have a scenario where i am showing week on week Sales in line chart. I want to change the color of line chart symbol as per the below thing: if current week sales amount is less than prev week sales amount then current week sales symbol should be red..else green. same goes for other weeks, i.e. if prev week sales amount is less than prev to prev week sales amount, then prev week symbol should be red else green.

I am hoping an early reply as this is an urgent requirement.

Thanks

Re: Color coding in line chart

ogautier62 — Thu, 31 May 2018 17:21:27 GMT

May be try to use two expression

One with sales< the other> with two different colors

Re: Color coding in line chart

Anonymous — Thu, 31 May 2018 17:55:57 GMT

Hi,

You can use PEEK function to get the value of prior week and compare with current week. Then use this in Expression --> Background Color.

Hope this helps.

Thanks

Re: Color coding in line chart

Frank_Hartmann — Thu, 31 May 2018 18:30:21 GMT

like this?

Re: Color coding in line chart

ogautier62 — Fri, 01 Jun 2018 07:27:27 GMT

is this what you want ?

it seems good I didn't think at that