Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reinholdgraf
Creator
Creator

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
sunny_talwar

I think you might need this

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

View solution in original post

17 Replies
sunny_talwar

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

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

reinholdgraf
Creator
Creator
Author

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
Creator
Creator
Author

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
Creator
Creator
Author

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

Capture.PNG

reinholdgraf
Creator
Creator
Author

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

sunny_talwar

Stdev(TOTAL Value)