Discussion Board for collaboration on QlikView Layout & Visualizations.
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>')
Go to Solution.
Try with Below()
=If(Below(Sales) < Sales, '<S2>','<S1>')
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.
Clever's logic seems to be working for me
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.