topic Re: Standard deviation in script in QlikView

Standard deviation in script

sivarajs — Mon, 21 May 2012 07:23:14 GMT

Hi,

I want to calculate standard deviation in script

currently am trying the following

load stdev(fieldname) as fieldname1

from x.qvd group by fieldname;

But am not getting any values in fieldname1

Anyone temme how to do standard deviation in script

Hope its clear... need your suggestions

Thanks

Sivaraj S

SunilChauhan — Mon, 21 May 2012 07:28:47 GMT

you can use

load stdev(sum(fieldname)) as fieldname1

from x.qvd group by fieldname;

see the example below.

it showing me 100 as stddev.

tab1:

Load * inline [

fieldname1,fieldname2

A,100

B,200

c,300

];

load stdev(fieldname2) as fieldname1,

1 as junk

resident tab1;

drop table tab1;

Hope this helps

sivarajs — Mon, 21 May 2012 07:44:37 GMT

Hi sunil,

using sum with stdev showing error as nested aggr not allowed

Mon, 21 May 2012 07:45:38 GMT

Hi,

you can do that with following code (just skip group by clause from statement in your first post)

STANDARD_DEVIATION:

load stdev(fieldname) as fieldname1 from x.qvd;

regards