# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for
Did you mean:  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

17 Replies  Creator
Author

OK for this example.

Coming to the management-requirement, there are some other problems to solve:

The table shows only 1 line per article, where stock-value, consumption, average and standard-deviation have to be shown and calculated according to several filters (period, divison, etc.)

In this case, the avg-/stdev-formulas have to be adjusted somehow, right ?

Pls see attachement, where avg/stdev are still calculated for the whole table.  MVP

What is not right in the image? Can you point out? What do you expect to see?  Creator
Author

the red marked columns are wrong.

The values should be calculated   PER LINE

(and not for the whole table in sum. You can see, that the values are the same for each line)

In the end, the values in those columns should vary from line to line.  MVP

What is the current expression used?  Creator
Author

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

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

I think you might need this

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

OK. This works now.

Thanks a lot   Contributor II

Hey, Can you help me with some doubt?

I'd to make a standard deviation in a range date, I use this :

=avg(aggr(SUM({<decision={'AP'}>}amount)/Sum(amount),date))

but in my graphic this formula gets the standard deviation variable, I would like to have the standard deviation in the fixed date in graph.

Thanks, Tags
Community Browser