topic analysis for six sigma in QlikView

analysis for six sigma

Tue, 25 Oct 2011 13:19:27 GMT

Hello Everyone,

I'm performing a six sigma like analysis on a set of data.

What I want to do is:

- given a sample as:

month value

1 4

1 9

1 88

1 99

2 100

2 40

2 500

etc

I want to count the "value" out of the 3 sigma and mean limit.

I create a simple chart, a straight table:

- dimension is "month"

- "ctlimit" is : avg(value) + 3*stdev(value)

so far so good

counting against a fixed value is good, e.g.

- count({$<value= {'<=100'}>} value)

it works fine

BUT.. if I add a dynamic control the expression does not work anymore

count({$<value= {'<=ctlimit'}>} value)

what's wrong???

thank you in advance

Thu, 27 Oct 2011 07:34:23 GMT

er....

I inderstood the issue is in the "Set" I choose... but still I'm unable to make that formula works...

so still seeking for help

Wed, 30 Nov 2011 12:49:39 GMT

i think this might help

Wed, 14 Dec 2011 11:12:40 GMT

thank you.

that discussion has been deleted...

do you have a copy of it??