QlikView App Dev

[idodel]

Hello, I am having a problem with a straight table measures. I am trying to show the hours taken for each employee in period time number 2 (p2 column), and i have a set analysis there.

From some reason, only when I click on specific employee it shows the right number. It represent a wrong number generally when I don't choose a employee.

So it has a filter problem that I don't understand yet.

Please help me find it out.

wrong number - when employee is not filtered yet

right number - after employee is filtered

the set analysis is like this:

num(sum( {$<

*Some filters*,

Period={'P2'}
>}[Reported Hours]),'##0')

Thanks

[Gonzales36]

Thanks