topic Re: SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done??? in QlikView

SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done???

Wed, 18 Jul 2012 20:35:19 GMT

I am in a quality team within a big hospital and we use (need) a lot SPC charts. I know it is not a built-in feature and we need more efforts to get it done. There are some .NET contorls can do it, and there are also some Excel add-ins can do it easily. I would like to see whether some common SPC charts such as run chart, g chart, xmr chart can be created in Qlikview easily. If you can share some examples, that will be great. I know some genius in this community might have already done it. Please share your excellent work. Thank you in advance.

Longmatch

Re: SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done???

rwunderlich — Wed, 18 Jul 2012 20:54:37 GMT

Here's an example of a Control Chart.

-Rob

Re: SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done???

Wed, 18 Jul 2012 21:01:22 GMT

Thank you very much for your quick response. This chart works when sample size is similar. Can we create different control limits if sample size is different? Please refer to the document here!

Re: SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done???

rwunderlich — Wed, 18 Jul 2012 21:22:39 GMT

If you can calculate the control lines, you can plot them . I'm smiling because I've seen a number of different definitions for calculating control limits. My example used the simple STDEV method.

My example used reference lines to display the fixed control lines. If you want to vary by dimension, plot them as another expression instead of a reference line.

-Rob

Re: SPC (Statistical Process Control) charts in Qlikview! Too difficult to be done???

Wed, 18 Jul 2012 21:26:39 GMT

Great! Do you have or can you find a similar sample? If not, could you please give me some guidance? I really want to know how to do it.