topic Re: Bringing back overlap line in QlikView

Bringing back overlap line

kkkumar82 — Fri, 27 Jul 2018 07:47:00 GMT

Hi community,

Attached is a qvw file in which I have a line chart with 4 expressions.

At some point of time at Dimension value 10(I hope) the line Q418 is going down under Q318, and there is requirement for me to bring up the Q418 line over Q318 line as Q418 is the current Quarter for us.

Any tricks will help me

Thanks

Kiran

Re: Bringing back overlap line

kkkumar82 — Fri, 27 Jul 2018 07:47:35 GMT

Also the order of the legends is important for me , I cannot change them

Re: Bringing back overlap line

kkkumar82 — Fri, 27 Jul 2018 09:22:30 GMT

marcus_sommer‌

stalwar1‌

rwunderlich‌

Any tricks please

Re: Bringing back overlap line

sunny_talwar — Fri, 27 Jul 2018 11:13:54 GMT

Not sure I understand what is going on? You want to see blue instead of green here?

Re: Bringing back overlap line

kkkumar82 — Fri, 27 Jul 2018 12:44:49 GMT

Yes sunny when the values are overlapping I want to see Blue line on the top rather than green line

Re: Bringing back overlap line

sunny_talwar — Fri, 27 Jul 2018 13:06:27 GMT

I am not sure of a way to do this...

Re: Bringing back overlap line

kkkumar82 — Fri, 27 Jul 2018 13:17:34 GMT

Yeah, I searched for some properties in the chart but couldn't get it.

Thanks for the reply , have a nice weekend.

Re: Bringing back overlap line

vkish16161 — Fri, 27 Jul 2018 16:50:13 GMT

Maybe try this:

If (Dimension =10, Sum(Sales) + 50, Sum(Sales))

This will give the wrong value but it'll skew it enough to make them look distinct.

Re: Bringing back overlap line

kkkumar82 — Sat, 28 Jul 2018 17:12:53 GMT

Thanks Vishnu,

but I cannot use this as the graphs deviates the analysis

Re: Bringing back overlap line

rwunderlich — Mon, 30 Jul 2018 18:29:29 GMT

Reorder the expressions and then check "reverse" in the legend properties.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Bringing back overlap line

kkkumar82 — Tue, 31 Jul 2018 11:18:56 GMT

Thanks Rob for the trick, it worked for me