topic Re: How To Calculate Standard Deviation ? in QlikView

How To Calculate Standard Deviation ?

Tue, 25 Aug 2015 21:11:36 GMT

Re: How To Calculate Standard Deviation ?

swuehl — Tue, 25 Aug 2015 21:41:00 GMT

You want to create a field with a constant value (the stddev of your other field values)?

You can do this using simple maths:

Standard deviation - Wikipedia, the free encyclopedia‌

But why don't you want to use the QV function?

edit:

If you want to create a field for the standard deviation, maybe like

LOAD * INLINE [

Column A

];

JOIN LOAD

Stdev([Column A]) as STDEV

RESIDENT A;

Re: How To Calculate Standard Deviation ?

jagan — Wed, 26 Aug 2015 02:08:34 GMT

Hi,

Check below from Qlikview Help file (F1)

For Front end

stdev([{set_expression}][ distinct ] [ total [<fld { , fld } >] ] expression)

Returns the aggregated standard deviation of expression or field iterated over the chart dimension(s).

This function has the same limitations for nested aggregation as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function. The stdev function supports Set Analysis and the total qualifier in the same way as the avg([{set_expression}] [ distinct ] [ total [<fld { , fld } >]] expression) function.

Examples:

stdev(Sales)

stdev(X'Y/3)

stdev(distinct Price)

stdev(total Sales)

stdev({1} total Sales)

For Backend script

Returns the standard deviation of expression over a number of records as defined by a group by clause. If the word distinct occurs before the expression, all duplicates will be disregarded.

Example:

Load Month, stdev(Sales) as SalesStandardDeviation from abc.csv group by Month;

Hope this helps you.

Regards,

Jagan.

Re: How To Calculate Standard Deviation ?

Anonymous — Wed, 26 Aug 2015 02:46:02 GMT

Hi,

Please go through this link:

Re: standard deviation (rangestdev) for my values