topic Need Help in Joining two datasets in QlikView

Need Help in Joining two datasets

yashcena — Sat, 16 Nov 2024 04:57:38 GMT

Hi,

I have this first dataset:

I have the two other datasets:

Release and Sprint

I have created a chart like this in QV:

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

Re: Need Help in Joining two datasets

uacg0009 — Fri, 14 Dec 2018 09:52:42 GMT

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

Re: Need Help in Joining two datasets

yashcena — Fri, 14 Dec 2018 10:21:43 GMT

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!

Re: Need Help in Joining two datasets

uacg0009 — Fri, 14 Dec 2018 10:14:14 GMT

Hi Yashcena,

Hope that's what you want.

Aiolos

Re: Need Help in Joining two datasets

yashcena — Fri, 14 Dec 2018 10:23:05 GMT

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

Re: Need Help in Joining two datasets

uacg0009 — Fri, 14 Dec 2018 10:28:32 GMT

Glad to help you~