Need to get duration

[#1]

Pleae find the attached files.

On the top, there is a graph showing a plan to be hire people. On the bottom, the table shows actual list of employees in present and past.

What I want to do with this Qlikview file is:

When some portion of graph is selected, I want to see the number of people who worked during the selected duration, between Start and Quit.

For example, when I select  July-2013, I must see 7 people on the table, which are Person NO = 101,104,105,107,109,112, and 116.

Is there anyway that I can do this?  Please give me a help.

Thank you.

[Kushal_Chawda]

please see the attached file.

[#3]

Nothing much has been changed, except adding two filters.. And it still gives me unexpected number.

Thank you.

[avinashelite]

Hi Dae,

I checked you file, data is not proper to work on . can u please provide the valid data and please elaborate the requirement.

[#5]

Avinash,

Pelase find the attachment at the top of this page. I put all information that the excel file includes. Hope it works at this time.

Thank you.

[ramoncova06 · Accepted solution]

check this post is the same that you want to do

Set Analysis Date Range