topic Re: SPC / Run Chart in QlikView

SPC / Run Chart

Wed, 18 May 2016 13:12:11 GMT

Hi,

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?

Thanks,

Tim

Re: SPC / Run Chart

MarcoWedel — Wed, 18 May 2016 21:18:31 GMT

Hi,

maybe altering the expressions suggested in this thread Control startto test for UCL/LCL violations?

hope this helps

regards

Marco

Re: SPC / Run Chart

joe_warbington — Wed, 21 Feb 2018 16:19:22 GMT

Hi tjm20111102,

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:

Variation and importance in Quality Improvement (QI) projects within healthcare
The Run Chart
Run Chart Rules
Simple QlikView run chart
(Statistical) Process Control (SPC)
‘I’ ‘P’ ‘C’ ‘U’ - Examples
Rare events / time between

Be sure to check this out: http://bit.ly/2Cc1GlK

Re: SPC / Run Chart

yiyihuang — Wed, 27 Jun 2018 03:03:38 GMT

Hi Joe

how do you calculate you SD for P Chart?

Re: SPC / Run Chart

danielgargiulo — Sat, 09 Feb 2019 01:42:43 GMT

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: extensions@acumenbi.co.nz .

Re: SPC / Run Chart

graham-crooks — Thu, 17 Dec 2020 14:59:26 GMT

Hi Joe

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

Re: SPC / Run Chart

danielgargiulo — Thu, 17 Dec 2020 19:21:20 GMT

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 extensions@acumenbi.co.nz i can provide you a demonstration and a trial version for 30 days. Kind regards, Dan