topic Re: Good Set Analysis Practices... in QlikView

Good Set Analysis Practices...

leocattqv — Mon, 16 Apr 2018 19:25:25 GMT

Hello community -

I am creating a control chart and am almost there, but I am having trouble with the coding of the upper control limit. I am wondering if there is some syntax that I am not getting right.

Variables:

vPValue = Sum([Quantity]) / Sum([Sales])

vUCL = ($(vPValue) + 3 * sqrt($(vPValue)*(3-($(vPValue))) / Sum($(vActualShip))))

Question 1 - Should I be using variables within Variables?

Question 2 - is there a better way to write the vUCL variable?

Any thoughts or suggestions would be apprecaited - if there is a best practice guide to writing better code, then I would love to be pointed that way.

thanks

-L

Re: Good Set Analysis Practices...

sunny_talwar — Tue, 17 Apr 2018 02:20:56 GMT

UCL needs to be a straight line? If that is true then may be you need to Reference line on the Presentation tab....

Re: Good Set Analysis Practices...

leocattqv — Tue, 17 Apr 2018 17:12:04 GMT

Hi Sunny,

No, it needs to be a variable line depending on the Numerator (ship)

my concern is that both lines are the same even though the formula is different.