Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

analysis for six sigma

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

      f.

3 Replies
Not applicable

analysis for six sigma

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

      f.

Not applicable

analysis for six sigma

Not applicable

analysis for six sigma

bandanakarki,

thank you.

that discussion has been deleted...

do you have a copy of it??

    f.