Discussion board where members can get started with Qlik Sense.
I need to calculate average and standard-deviation of stock-movements.
Average is calulated as following and working:
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 ?
Go to Solution.
I think you might need this
Stdev(Aggr(Sum([LV_M-Abgang-Gesamt]), Division, Lagerort, Artikelgruppe, [LV_JahrMonat/YearMonth]))
Did you try the Stdev() function? Stdev - chart function ‒ QlikView
yes. No output
I tried as well:
Would you be able to share a sample with the desired result?
The calculated standard-deviation (21.826) is the target.
I also watched the following blog:
Can you attach the Excel here?
Uploading a Sample
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
how does your formula for standard-dev. look like in this sample ?