topic Re: Stdev help. in QlikView

Stdev help.

slondono — Tue, 01 Dec 2015 21:21:37 GMT

Hello everybody

I have a problem when i try to calculate stdev for many people. It works for just 1 person but i dont get it for many people.

Here the problem

1. For 1 person is correct

I know that is good because excel give the same result

This is the expression:

(Calendario.AnoNomina = Year)

And this happen when i delete the IDEmployee filter

What should I do to change the expression so that it does not happen? I need de stdev for every person.

Thanks to all

swuehl — Tue, 01 Dec 2015 21:49:09 GMT

Try adding the Cod Trabjador field to your aggr() dimensions:

Stdev( Aggr( Sum(#Valor), [Cod Trabajador], Calendario.AnoNomina))

slondono — Tue, 01 Dec 2015 22:26:40 GMT

Perfect. So much thanks