topic Re: Capability Charts in QlikView

Capability Charts

manideep78 — Mon, 24 Feb 2014 04:28:58 GMT

Dear Community,

Is there a way to draw capability charts in Qlikivew. Please let me know How can I proceed to do these type of reports.? Please see the attached Image.

Bars - Histogram

Dashed Black line - Normal Distribution using Over all standard deviation

solid red line - Normal Distribution using Pooled standard deviation

LSL

USL

Please let me know how can we do this?

thanks a ton in advance

Regards

manideep

Re: Capability Charts

sujeetsingh — Mon, 24 Feb 2014 05:08:09 GMT

Hi ,

May these will help you

http://community.qlik.com/thread/53749

Re: Capability Charts

manideep78 — Mon, 24 Feb 2014 09:59:57 GMT

Thanks for the Response. It doesn't meet my requirement. Can you please let me know how can we achieve the statistical charts like Capability Charts in Qlikview. and also please let me know how can we draw vertical Reference Lines.

Regards

Manideep

Re: Capability Charts

manideep78 — Mon, 24 Feb 2014 11:37:05 GMT

Can anyone Please give an idea on this?

Re: Capability Charts

rajeshvaswani77 — Mon, 24 Feb 2014 11:45:34 GMT

Hi Manideep,

You need a combo chart. Choose line or bar options for various expressions.

thanks,

Rajesh Vaswani

Re: Capability Charts

vikasmahajan — Mon, 24 Feb 2014 11:50:38 GMT

PFA sample, More Line add one extra expression make it line.

May this help you.

Vikas

Re: Capability Charts

manideep78 — Mon, 24 Feb 2014 15:00:33 GMT

HI Rajesh,

How Can I plot those Vertical Lines for USL and LSL?

Re: Capability Charts

manideep78 — Mon, 24 Feb 2014 15:02:09 GMT

Hi Rajesh,

Thanks for the reply and here my calculation is related to complex Statistical expression. I need to find statistical normal distribution value in Qlikview.