topic Re: Line Chart - Changing Line Style for downward trend in QlikView

Line Chart - Changing Line Style for downward trend

Fri, 29 Jul 2016 20:20:39 GMT

How can the Line Style of an expression be changed from Solid to Dashed only on a downward trend from the previous value?

This chart should show dashed line from May 2016 to Jun 2016 and from Jul 2016 onward.

The formula in the Line Style (red line only) is as follows:

=If(Above(Sales) > Sales, '<S2>','<S1>')

Re: Line Chart - Changing Line Style for downward trend

Clever_Anjos — Fri, 29 Jul 2016 20:44:32 GMT

Try with Below()

=If(Below(Sales) < Sales, '<S2>','<S1>')

Re: Line Chart - Changing Line Style for downward trend

Mon, 08 Aug 2016 12:52:24 GMT

I've tried that, but it shows the dashed line style on the upward trend. With Above, I get a mix of the dashed line style on both upward/downward trends.

Re: Line Chart - Changing Line Style for downward trend

sunny_talwar — Mon, 08 Aug 2016 15:37:15 GMT

Clever's logic seems to be working for me

Re: Line Chart - Changing Line Style for downward trend

Mon, 08 Aug 2016 16:05:40 GMT

Well, I rebuild the chart using Clever's suggestion and now it seems to be working. Not sure what the issue was, but Below() worked this time. Thank you.

Re: Line Chart - Changing Line Style for downward trend

sunny_talwar — Mon, 08 Aug 2016 16:11:21 GMT

Good