4 Replies Latest reply: Apr 24, 2015 3:28 AM by jagan mohan rao appala

# CpK in Qlikview

Dear Folk,

whehter there is any inbuilt function in qlikview in order to implement Cpk of 6 sigma in qlikview. or any other way how we can find this.

thanks and Regards.

• ###### Re: CpK in Qlikview

Hi,

I think there is no direct function in Qlikview but we can achieve this

#### Formula :

###### Where,

USL = Upper Specification Limit, LSL = Lower Specification Limit.

##### Example :

Food served at a restaurant should be between 38°C and 49°C when it is delivered to the customer. The process used to keep the food at the correct temperature has a process standard deviation of 2°C and the mean value for these temperature is 23. What is the process capability of the process?

##### Given,

USL (Upper Specification Limit) =49°C LSL (Lower Specification Limit) =39°C Standard Deviation =2°C Mean = 23

##### To Find,

Process Capability & Process Capability Index

= Min((49 - 23) / (3 * 2), (23 - 39) / (3 * 2))

Hope this helps you.

Regards,

Jagan.

• ###### Re: CpK in Qlikview

Dear Jagan,

do you have any qlikview application where this is implemented.

thanks

• ###### Re: CpK in Qlikview

Hi,

I do not have sample application.

Regards,

Jagan.