# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor

## Standard Deviation in a chart

Hi.

I need to calculate average and standard-deviation of stock-movements.

Average is calulated as following and working:

AVG(TOTAL Aggr(Sum([LV_M-Abgang-Gesamt]),[LV_JahrMonat/YearMonth]))

Standard-Deviation - actually no conclue. Tried a few approaches, but not working.

Target must be the standard-deviation related only(!) to the selected period.

Any idea ?

Regards,

Reinhold

1 Solution

Accepted Solutions MVP

## Re: Standard Deviation in a chart

I think you might need this

Stdev(Aggr(Sum([LV_M-Abgang-Gesamt]), Division, Lagerort, Artikelgruppe, [LV_JahrMonat/YearMonth]))

16 Replies MVP

## Re: Standard Deviation in a chart

Did you try the Stdev() function? Stdev - chart function ‒ QlikView

Stdev(TOTAL Aggr(Sum([LV_M-Abgang-Gesamt]),[LV_JahrMonat/YearMonth]))

Contributor

## Re: Standard Deviation in a chart

yes. No output

I tried as well:

Stdev(TOTAL

aggr(

sum (

{<[LV_JahrMonat/YearMonth]={'>=\$(=min([LV_JahrMonat/YearMonth]))<=\$(=max([LV_JahrMonat/YearMonth]))'}>}

[LV_M-Abgang-Gesamt], [LV_JahrMonat/YearMonth]

)

)

)

Same Result... MVP

## Re: Standard Deviation in a chart

Would you be able to share a sample with the desired result?

Contributor

## Re: Standard Deviation in a chart

Yes.

The calculated standard-deviation (21.826) is the target.

I also watched the following blog: MVP

## Re: Standard Deviation in a chart

Can you attach the Excel here?

Contributor

## Re: Standard Deviation in a chart

attached MVP

## Re: Standard Deviation in a chart

I know this is just a sample, but Stdev seems to be working here... the only difference is that it is sample standard deviation rather than populations standard deviation... for population, may be look here:

Help with Standard deviation Full population No... | Qlik Community Contributor

## Re: Standard Deviation in a chart

how does your formula for standard-dev. look like in this sample ? MVP

## Re: Standard Deviation in a chart

Stdev(TOTAL Value)