topic Need to get duration in QlikView

Need to get duration

Fri, 31 Oct 2014 03:53:41 GMT

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 — Fri, 31 Oct 2014 04:38:51 GMT

please see the attached file.

Fri, 31 Oct 2014 13:23:52 GMT

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

Thank you.

avinashelite — Fri, 31 Oct 2014 13:50:22 GMT

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.

Fri, 31 Oct 2014 14:18:03 GMT

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 — Fri, 31 Oct 2014 15:14:03 GMT

check this post is the same that you want to do