Skip to main content
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SPC / Run Chart


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?



6 Replies


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

hope this helps



Luminary Alumni
Luminary Alumni

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:

2018-02-21 10_16_50-Network Recording Player - Qlik Healthcare Dev Group September Gathering.png


Hi Joe

how do you calculate you SD for P Chart?

Partner - Creator
Partner - Creator

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

Contributor III
Contributor III

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

Partner - Creator
Partner - Creator

HI Graham, Information on Acumens Control Chart extension for Qlik can be found here: We have many customers using this in production. If you can email me at  i can provide you a demonstration and a trial version for 30 days. Kind regards, Dan