Change Point Analysis

chrismarlow — Thu, 05 Feb 2015 13:28:47 GMT

Hello,

Has anyone implemented anything using 'Change Point Analysis' in QlikView, along the lines of the following URL;

http://www.variation.com/cpa/tech/changepoint.html

At the moment I am thinking QlikView to calculate my raw inputs, MS Access to do the sums, then back into the final QlikView for display & sharing (so to be able to highlight series with high number/recent change points & probably highlight on charts).

To try to keep it in QlikView any ideas on the scripting around random sorting and the iterative sorting would be appreciated as well as accumulation/sum over time, where I seem to keep resorting to brute force (meaning to do the equivalent of <= in a join in SQL).

Will post back if I make any progress.

Re: Change Point Analysis

chrismarlow — Fri, 27 Feb 2015 17:54:04 GMT

So I couldn't get this to work at all, but I did find an alternative;

http://www.cs.cmu.edu/~eugene/research/full/compress-series.pdf

And loaded an interpretation here;

http://community.qlik.com/docs/DOC-8027

topic Change Point Analysis in QlikView

Change Point Analysis

Re: Change Point Analysis