Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I would like to know whether Qlikview can detect patterns in line chart, for example >= 6 points above or below the average line, trends of >=6 points in a row increasing or decreasing. Please see the two charts in the attachment. I also want the symbol at these data points to be red. I hope it can be done.
Any helps will be highly appreciated.
Longmatch
I believe there is no automatism for that built into QV.
But using an appropriate expression for e.g. the background color of your line chart, you can probably get some stuff done yourself (e.g. by comparing the current data point value to the distance from the avg(total ... ) line).
For example as background color attribute expression:
=if( fabs(Value - avg(TOTAL Value) ) >= 7, lightred() )
You will find good solutions to your question on this recent blog post.
This is exactly what I need. Thanks