Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

create a column based on dates from different rows

Hello!

Any ideas on how to make a table based on a criteria (end date (row 1) - start date(row 2)) for when "consecutive" dates belongs to a the new period. The periods belongs to a certain person.

PersonStart_dateEnd_datePeriod
A2010-01-012010-01-021
A2010-01-032010-01-042
A2010-01-102010-01-103
PersonPersonStart_dateOld periodPeriod
A2010-01-012010-01-0211
A2010-01-032010-01-0421
A2010-01-102010-01-1032

Kind Regards,

Markus

Community Browser