Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bohravanraj
Partner - Creator II
Partner - Creator II

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.

4 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check this link

CPK Formula

Hope it helps you.

Regards,

Jagan.

bohravanraj
Partner - Creator II
Partner - Creator II
Author

Dear Jagan,

Thnks for you reply,

do you have any qlikview application where this is implemented.

thanks

jagan
Luminary Alumni
Luminary Alumni

Hi,

I do not have sample application.

Regards,

Jagan.