topic Re: How do I find continuous interval in QlikView

How do I find continuous interval

Amphan — Thu, 22 Feb 2018 15:14:35 GMT

Hi, I have a table with 3,65 million rows where I have 365 dates and each date has 10 000 keys (PersonID) and some attributes. I'd like to convert this to a table with PersonID, attributes and a daterange of StartDate and EndDate like in the sample tables below. I do not now how to achive this, does anyone have an idea that could help me?

Original table:

New table:

TIA

Ola

Re: How do I find continuous interval

sunny_talwar — Thu, 22 Feb 2018 15:18:33 GMT

Should be easy like this

LOAD PersonID,

FirstName,

LastName,

Min(Date) as StartDate,

Max(Date) as EndDate

FROM ...

Group By PersonID, FirstName, LastName;

Re: How do I find continuous interval

Amphan — Fri, 23 Feb 2018 13:30:07 GMT

Worked perfectly, thanks! I got my new tables size down to only 4,6% of the original table!

//Ola