4 Replies Latest reply: May 12, 2014 6:49 AM by Fernando Barros RSS

    How to convert periods on work days

      Hi,

       

      I´ve been seeing several examples, by my Qlikview skills aren´t good enough yet. I would like to convert on load script this:

      ID da TarefaInício do períodoFim do período
      2428/4/14 15:3130/4/14 08:43
      1928/4/14 09:2528/4/14 15:30
      525/4/14 11:2525/4/14 12:39
      525/4/14 13:1225/4/14 18:03

       

      On this:

      ID da TarefaStartEnd
      2428/4/14 15:3128/04/14 18:00
      2429/04/14 09:0029/04/14 18:00
      2429/04/14 09:0030/4/14 08:43
      1928/4/14 09:2528/4/14 15:30
      525/4/14 11:2525/4/14 12:39
      525/4/14 13:1225/4/14 18:03

       

       

      Which means I need to show a time period (example ID #24) in work hours day by day. I need to do this on load script, because I need to use those dates after.

       

      I really appreciated any help.

       

      Fernando