Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
chrismarlow
Specialist
Specialist

Change Point Analysis

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.

1 Reply
chrismarlow
Specialist
Specialist
Author

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