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