topic standard deviation (rangestdev) for my values in QlikView

standard deviation (rangestdev) for my values

Wed, 09 Jan 2013 15:52:33 GMT

Dear community,

I am trying to calculate the standard deviation for my values but whatever I try (also with this community) it is not workin.

I guess I need to change the table into a crosstable to use the function rangestdev, but I am not quite sure how to do it.

For each month (1.2011, 2.2011) I need the standard deviation.

attached you will find the excel table.

Thanks a lot in advanced

Thomas

Re: standard deviation (rangestdev) for my values

nagaiank — Wed, 09 Jan 2013 16:05:58 GMT

The following script works:

Data:

LOAD ArtNum,

month,

value

FROM

TB02_20130109_165037.xls

(biff, embedded labels, table is Tabelle1$);

Data2:

NoConcatenate

LOAD month

, Stdev(value) as StdDev

Resident Data Group By month;

Alternatively after loading the Data table, create a straight table chart with name as Dimension and stdev(value) as expression, which also displays the standard deviation.

Re: standard deviation (rangestdev) for my values

Wed, 09 Jan 2013 16:15:06 GMT

Thank you very much. I did not found this function Stdev but only rangestdev