Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
idodel
Contributor III
Contributor III

set analysis ignoring field selections

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

wrong number.PNG

 

right number - after employee is filtered

right number.PNG

 

the set analysis is like this:

num(sum( {$<

*Some filters*,

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

 

 

Thanks

 

1 Reply
Gonzales36
Contributor
Contributor

Thanks