Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Creator
Creator

I was asked recently if I could produce a standard control chart or SPC chart in QlikView. So I thought I would share this on the blog.

SPC and Control charts are ways of tracking if a process is "in control". If you take a look at the Wikipedia entry below you can see that Control charts have been in existence for nearly a 100 years, and are still used today, especially with the introduction of 6 sigma in 1995.

"The control chart was invented by Walter A. Shewhart while working for Bell Labs in the 1920s. The company's engineers had been seeking to improve the reliability of their telephony transmission systems. Because amplifiers and other equipment had to be buried underground, there was a business need to reduce the frequency of failures and repairs. By 1920, the engineers had already realized the importance of reducing variation in a manufacturing process. Moreover, they had realized that continual process-adjustment in reaction to non-conformance actually increased variation and degraded quality. Shewhart framed the problem in terms of Common- and special-causes of variation and, on May 16, 1924, wrote an internal memo introducing the control chart as a tool for distinguishing between the two."

(https://en.wikipedia.org/wiki/Control_chart)

In this QlikView example of a control chart I have tried to give you a number of reference lines and also used the Standard Deviation functon to drive our control limits. The chart itself is dynamic and will react to any selections made wihtin the application. This will let you monitor your process control by any dimension you add such as Country, Region, Plant and also specific products and time periods.

spc.png

You can find the application and document here.

4 Comments
MVP & Luminary
MVP & Luminary

Thanks, Adam.

Erica Whalley has done an excellent blog post on Control Charts here:

http://qlikfit.blogspot.co.uk/2013/03/qlikview-lean-tips-1-how-to-highlight.html


Well worth a look.

0 Likes
1,672 Views
Master
Master

Thank you for the interesting information.

1,672 Views
Luminary
Luminary

We held an on-demand session with National Health Services (NHS) about how they built 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: https://youtu.be/OVkUOTA-GQw

0 Likes
1,448 Views
Luminary
Luminary

We held an on-demand session with National Health Services (NHS) about how they built 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: https://youtu.be/OVkUOTA-GQw

1,446 Views