populate custom missing months

Tue, 24 Jul 2012 10:47:18 GMT

Hi,

I have data in the foll. format:

aa2:

Load * INLINE

[ ObjID, StartDate, EndDate

OB1, '2012-04-01', '2012-07-25'

OB2, '2011-12-10', '2012-03-15'

OB3, '2012-06-20', '2012-06-25'

OB4, '2012-10-01', '2013-01-01'

];

Required:

OB1, 'APR-2012'

OB1, 'MAY-2012'

OB1, 'JUN-2012'

OB1, 'JUL-2012'

OB2, 'DEC-2011'

OB2, 'JAN-2012'

OB2, 'FEB-2012'

OB2, 'MAR-2012'

OB3, 'JUN-2012'

OB4, OCT-2012'

OB4, 'NOV-2012'

OB4, 'DEC-2012'

OB4, 'JAN-2012'

I need to generate missing months between start date and end date. Also, the generated months will be different for each of the records as month generation depends on the Start date and end date.

Can anybody please suggest as to how should I proceed to resolve this issue?

Thanks.

topic populate custom missing months in QlikView

populate custom missing months