Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hope ite helps!

Not applicable
Author

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
Author

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

Not applicable
Author

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!