Bringing back overlap line

[kkkumar82]

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

[kkkumar82]

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

[kkkumar82]

marcus_sommer‌

stalwar1‌

rwunderlich‌

Any tricks please

[sunny_talwar]

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

[kkkumar82]

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

[sunny_talwar]

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

[kkkumar82]

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

Thanks for the reply , have a nice weekend.

[vkish16161]

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.

[kkkumar82]

Thanks Vishnu,

but I cannot use this as the graphs deviates the analysis

[rwunderlich · Accepted solution]

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com