topic Re: standard deviation calculation in QlikView

standard deviation calculation

drohm002 — Wed, 25 Nov 2020 16:16:04 GMT

I have a table, see below. For each month, the minimum value is subtracted from the maximum value for that month to get a range (see formula in table). The range for Jan-2015 is 2,031. I want to calculate the standard deviation of the entire second column, the one that has the range of each month. In the expression tab under "total mode" I can show the standard deviation at the top of the column, like it is now. The std dev is 2,448. But I want to be able to create a variable or field that calculates this for me. Please help!

Re: standard deviation calculation

ogautier62 — Fri, 13 Jul 2018 06:44:11 GMT

Hi,

stdev(max(los_ico)-min(los_ico)) doesn't work ?

Daniel where is the problem exactly ?

regards

Re: standard deviation calculation

drohm002 — Fri, 13 Jul 2018 11:37:04 GMT

Hi Oliver, see the screen shot below. It is telling me there is an error in my expression.

Re: standard deviation calculation

ogautier62 — Fri, 13 Jul 2018 11:45:55 GMT

you are right,

it's not possible to have nested stdev and max/min

I tried with aggr, that works :

Stdev( aggr(max(los_icu),YearMonth)) - aggr(min(los_icu),YearMonth))

Re: standard deviation calculation

drohm002 — Fri, 13 Jul 2018 11:50:35 GMT

Nothing is populating, I typed in that formula exactly....see below.

Re: standard deviation calculation

ogautier62 — Fri, 13 Jul 2018 12:03:20 GMT

in the new column you have 2448 as total : it's not that ?

Re: standard deviation calculation

drohm002 — Fri, 13 Jul 2018 12:16:05 GMT

i got it, thanks!

Re: standard deviation calculation

ogautier62 — Fri, 13 Jul 2018 12:19:10 GMT

thanks

if you want it same column above,

use function : dimensionality()

= 0 it's the header subtotal

= 1 it's a row