Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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!

4 Replies
Not applicable

Re: Expand group of months to individual months line items

Hope ite helps!

Not applicable

Re: Expand group of months to individual months line items

Thank you At titude! for your reply. However, I am sorry I wasnt clear in my question above. The first table is my data (there are several hundreds of rows in that manner)

The second table is the way I want the output displayed.

Is this possible? Thanks

Not applicable

Re: Expand group of months to individual months line items

Not sure whether it is possible! If you can attach your application we can help you out...

Not applicable

Re: Expand group of months to individual months line items

Hi, Please see the QV application attached. The data has groups of months and I need to pull individual months out. Is there a way to do this?

The output needs to look like:

IDStartDtEndDtHours
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

Thanks in advance!

Community Browser