Remove data more than upper control limit (average+Stdev) in load script

Wed, 17 Jun 2015 20:39:09 GMT

I want to remove data that is more than average + standard deviation in load script:

These are the solutions that I tried:

Solution1:

if(round([Run time]-[collection Time]) <= avg(round([Run time]-[collection time])+Stdev(round([Run time]-[collection time]))),round(([Run time]-collection time])*24*60),) as AB

Load Error that I get: nested aggregation

Solution 2:

Stdev([Run time]-[Collection time] as std,

avg([Run time]-[Collection time] ) as avg.

....Then use these 2 in my chart expression

Load Error: expression not valid

Solution 3: I was thinking to define a variable in load and use variables instead of [Run time]-[Collection time]

But I am not sure of this neither. Does any have any ideas about nested aggregation and how it can be resolved?

**I also used set analysis for this , but since I am using an expression in my set it does not show any valid chart.

Re: Remove data more than upper control limit (average+Stdev) in load script

Wed, 17 Jun 2015 22:27:49 GMT

Hi,

Please have a look at the attached application, hope it helps!

Kiruthi

topic Remove data more than upper control limit (average+Stdev) in load script in QlikView

Remove data more than upper control limit (average+Stdev) in load script

Re: Remove data more than upper control limit (average+Stdev) in load script