4 Replies Latest reply: Aug 14, 2012 6:00 PM by qlikprog RSS

    Expand group of months to individual months line items

      Hi,

       

      I'm trying to change the start & end dates as follows:

       

      IDStartDateEndDateHours
      16/29/129/5/12100
      27/4/1212/8/1250

       

      IDStartDateEndDateHours
      16/29/126/30/12100
      17/1/127/31/12100
      18/1/128/31/12100
      19/1/129/5/12100
      27/4/127/31/1250
      28/1/128/31/1250
      29/1/129/30/1250
      210/1/1210/31/1250
      211/1/1211/30/1250
      212/1/1212/8/1250

       

      I'm unable to break the months apart into individual months. Any help is greatly appreciated!

      Thanks!