Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Need Help in Joining two datasets

Hi,

I have this first dataset:

Capture.JPG

 

I have the two other datasets:

Release and Sprint

Capture2.JPG         Capture3.JPG

I have created a chart like this in QV:

Capture4.JPG

 

I want to include Sprint in this chart but dont have any key between them in my original application. (The snapshots are from a mockup). I just have Release dates and Sprint dates.

 

Is there a way to join sprint data with main data?

 

Thanks,

YASH

 

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi Yashcena,

Hope that's what you want.

Need Help in Joining two datasets.PNG

Aiolos

View solution in original post

5 Replies
Highlighted
Partner
Partner

Hi Yashcena,

I think that depends on how you want to merge your data, I guess maybe what you want is 

if "Date" is between SprintStart and SprintEnd, then join the "Sprint" column to the first dataset.

Is that correct?

If yes, you may need to use intervalmatch(), you will get the result.

Aiolos

Highlighted
Contributor II
Contributor II

I actually want to see all the Sprints that fall within a Release.

 

Both Release and Sprint have End and Start dates. How should I use intervalmatch()?

TIA!

 

Highlighted
Partner
Partner

Hi Yashcena,

Hope that's what you want.

Need Help in Joining two datasets.PNG

Aiolos

View solution in original post

Highlighted
Contributor II
Contributor II

Thank you! This is what I was looking for. 🙂

Highlighted
Partner
Partner

Glad to help you~Smiley Wink