0 Replies Latest reply: Jul 11, 2018 12:17 PM by Cristian Jorge RSS

    Restart week count for labor.

    Cristian Jorge

      Hello, Chic @ s

      I'm trying to get the number of weeks based on the LABOR.

       

      Objective:

      Get N ° Weeks per person based on LABOR.

       

      Logic:

      Each person starts a LABOR on a certain date, the count of the week begins (Monday to Sunday is a week).

      When that LABOR ends, restart the week count with another LABOR.

      Example:

       

      A "SEMANA" field was added in the Excel to make an example of how it should appear in Qlikview.

      The "N ° PERSONAL = 3397" is you have several LABOR from May to July.

      As it is displayed in the week field, the countdown is restarted every 7 days (it is counted from Monday to Sunday).

       

      Captura.PNG

       

      If we filter the "LABOR = 'PODA DE PRODUCCIÓN'", we realize that the count is restarted, until "WEEK = 5", because it only performs that LABOR.

       

      Captura.PNG

      Captura.PNG

      please help me get the amount of the week according to the work, date and staff.

      Greetings.

      I attach the excel.