Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How To Calculate Standard Deviation ?

hi

3 Replies
Highlighted
MVP
MVP

Re: How To Calculate Standard Deviation ?

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

A:

LOAD * INLINE [

Column A  

   1                            

   5                            

   6                            

   8                           

   15                          

];

JOIN LOAD

Stdev([Column A]) as STDEV

RESIDENT A;

Highlighted
MVP & Luminary
MVP & Luminary

Re: How To Calculate Standard Deviation ?

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.

Highlighted
Specialist II
Specialist II

Re: How To Calculate Standard Deviation ?

Hi,

Please go through this link:

Re: standard deviation (rangestdev) for my values