Qlik Community

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

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

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]))

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

Re: Standard Deviation in a chart

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

reinholdgraf
Contributor

Re: Standard Deviation in a chart

Yes.

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

I also watched the following blog:

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

Re: Standard Deviation in a chart

Can you attach the Excel here?

Uploading a Sample

reinholdgraf
Contributor

Re: Standard Deviation in a chart

attached

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

Capture.PNG

reinholdgraf
Contributor

Re: Standard Deviation in a chart

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

Re: Standard Deviation in a chart

Stdev(TOTAL Value)

Community Browser