5 Replies Latest reply: Oct 31, 2014 11:14 AM by Ramon Covarrubias RSS

    Need to get duration

      Untitled.jpg
      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.