Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
slondono
Partner - Creator II
Partner - Creator II

Stdev help.

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

1.PNG

I know that is good because excel give the same result

3.PNG

This is the expression:

2.PNG

(Calendario.AnoNomina = Year)

And this happen when i delete the IDEmployee filter

4.PNG

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

Thanks to all

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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

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

slondono
Partner - Creator II
Partner - Creator II
Author

Perfect. So much thanks