Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView Control (SPC) Chart

abyqlik_com
Contributor

QlikView Control (SPC) Chart

How do we create a simple Control or SPC chart in QlikView?

You can see how to do this in the attached Application and Document.

I have also placed a short blog post on the QlikView Design Blog.

ABY

Labels (1)
Attachments
Comments
anandathome
Contributor

Hi Adam,

    Thanks for the post. It is quite informative and will help many developers.

Regards,

Anand.

danielgargiulo
New Contributor III

HI Adam. I wonder if you have time to take a look at a recent query i have put on Qlik Community regarding advanced control charts? http://community.qlik.com/message/446647#446647

kind regards

dan

josephinetedesc
Contributor III

Hi Adam, re the formula

[Mean Process Time] + Deviation.

I can see where [Mean Process Time] comes from - I did not realise you could re-use a formula this way.

I cannot find where Deviation comes from (what is the formula behind this?)

Thank you I am working my way through your example.

Jo

Not applicable

Hi,

I have a bar chart , and this is my expression in the chart

Expression : COUNT(if([SLA_DAYS_PAST]<=0,[PPL_ID]))/COUNT(if([SLA_FLAG]=-1,[PPL_ID]))  (sl_flag_past<=0 indicates compaints that are taken care of on or before due dates) and (sla_flag=-1 indicates all the closed complaints)

Calculated Dimension : if(CLOSE_DATE>=vMinDate, MonthName(CLOSE_DATE))

Now, first of all I need to build an SPC CHART, so I have calculated the average value using this expression:

Average: COUNT(TOTAL <PPL_ID> if([SLA_DAYS_PAST]<=0,[PLL_ID]))/COUNT(TOTAL<PPL_ID> if([SLA_FLAG]=-1,[PPL_ID]))

Now to calculate upper and lower control limits, i need to get the standard deviation:

uppercontrol_limit : average+STDEV

lower control_limit=average=STDEV

So, I need a formula to find the STDEV. I have a dead line, and i really appreciate your time.

-Sarayu

Employee
Employee

Hi aby@qlik.com,

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: http://bit.ly/2Cc1GlK

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

qlikview_yj
Contributor

Thanks for the post.

toddrjohnson
Visitor

Just wanted to drop a quick warning that the control limits in the sample document and chart above are incorrect. They are based on the standard deviation, which will typically inflate the limits. The correct way to calculate limits for an X chart is to use the mean (or sometimes) median two point moving range. I have examples of this implemented in Tableau for anyone interested. And note that Tableau also has examples up that also incorrectly use the standard deviation. The best article on how to calculate the limits correctly is here: https://www.qualitydigest.com/inside/twitter-ed/individual-charts-done-right-and-wrong.html

Version history
Revision #:
1 of 1
Last update:
‎04-30-2013 11:27 AM
Updated by: