topic Re: How to detect patterns from line chart? in QlikView

How to detect patterns from line chart?

Tue, 02 Apr 2013 14:11:36 GMT

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

Re: How to detect patterns from line chart?

swuehl — Tue, 02 Apr 2013 14:41:54 GMT

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() )

Re: How to detect patterns from line chart?

Thu, 04 Apr 2013 01:57:10 GMT

You will find good solutions to your question on this recent blog post.

http://qlikfit.blogspot.com/

Re: How to detect patterns from line chart?

Thu, 04 Apr 2013 05:51:16 GMT

This is exactly what I need. Thanks