Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to detect patterns from line chart?

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

3 Replies
swuehl
MVP
MVP

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

Not applicable
Author

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

http://qlikfit.blogspot.com/

Not applicable
Author

This is exactly what I need. Thanks