Variance / écart type

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

Hi,

I've got an error with variance in qlikview

This is the series of grades obtained in the by 70 students

I need to calculate variance for each country such as

I’ve used formula

sum(

(

NB_STU

)

sqr(

NOTES -

sum(

total

Aggr(Sum(NOTES * NB_STU), COUNTRY)

/Aggr(Sum(NB_STU), COUNTRY)

)

sum(Aggr(Sum(NB_STU), COUNTRY))

It works only if I filter data on a country

PAYS	VARIANCE
PAYS1	9,37

But KO when no filter

I can’t identify what is wrong, could someone help please?

Thanks a lot

Re: Variance / écart type

ogautier62 — Thu, 24 May 2018 08:14:40 GMT

hello,

use function stdev() for standard deviation it's more simple,

regards

jsdondon — Thu, 24 May 2018 14:36:59 GMT

Hi,

Thanks for the function but I can't see how to use it with two kpi

ogautier62 — Thu, 24 May 2018 16:17:17 GMT

Remove word total in sum (total aggr(

ogautier62 — Fri, 01 Jun 2018 11:38:02 GMT

I apologize you're rigth for your formula, stdev doesn't work

regards