set analysis ignoring field selections

idodel — Sun, 25 Jul 2021 13:16:17 GMT

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

Re: set analysis ignoring field selections

Gonzales36 — Tue, 27 Jul 2021 09:24:31 GMT

Thanks

topic set analysis ignoring field selections in QlikView

set analysis ignoring field selections

Re: set analysis ignoring field selections