Standard Deviation in a chart

[reinholdgraf]

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

[sunny_talwar]

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

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

[reinholdgraf]

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...

[sunny_talwar]

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

[reinholdgraf]

Yes.

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

I also watched the following blog:

https://community.qlik.com/thread/218128

[sunny_talwar]

Can you attach the Excel here?

Uploading a Sample

[reinholdgraf]

attached

[sunny_talwar]

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

[reinholdgraf]

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

[sunny_talwar]

Stdev(TOTAL Value)