I have managed to create an SPC/Run Chart that highlights data points that fall above or below the Upper or Lower contol lines. What I am trying to work out is how to highlight a run of 7 points either above or below the controls?
Is this possible?
We have an on-demand session with the NHS and how they build and leverage Statistical Process Control Charts (SPC) and Run Charts in QlikView and Qlik Sense. johnmackintosh covers these topics in depth:
Be sure to check this out: http://bit.ly/2Cc1GlK
We have also released a Control Chart extension for Qlik Sense. More information and a 60 day trial can be downloaded from here.
Key features include: • Outliers Highlighted • Runs ‘above’ and ‘below’ the average highlighted • Trends up and down highlighted • Moving average based on Runs and/ or Trend triggers
Key configuration options include: • Customise Labels for Dimensions, Measures and Rules • Customise Line and point style for Dimensions, Measures and Rules • Pick the number of points to set the highlighting criteria for both Runs and Trends
For more information email: firstname.lastname@example.org .
I'm really interested in being to accomplish this and would like to see the presentation to which you refer. Is there an up-to-date link / source for this please? (As of Dec 2020, link in the post leads to 'Unavailable').
HI Graham, Information on Acumens Control Chart extension for Qlik can be found here: https://acumenbi.co.nz/qlik/acumen-control-charts/ We have many customers using this in production. If you can email me at email@example.com i can provide you a demonstration and a trial version for 30 days. Kind regards, Dan