I got this requirement from the business which is quite tricky, and I would like to know whether it is possible to handle with Qlikview (if yes, in which stage) or not since I started to know Qlikview a month ago only.
The table stores the events with:
Event_ID (unique number), Event_Description, Event_Organiser, Event_Date
| Event_ID | Event_Description | Event_Organiser | Event_Date |
|---|
| 1 | A | X | 08.07.2014 |
| 2 | A | X | 09.07.2014 |
| 3 | A | X | 10.07.2014 |
| 4 | B | Y | 12.07.2014 |
| 5 | A | X | 15.07.2014 |
An entry is created in the DB per event and per day and we need to regroup the events by the consecutive days, which means,
if the event has the same description and organiser, we take the consecutive dates and consider that the event last for N days
The required outcome is as following (if possible assign a group ID which is the "real" Event ID and not the numeric one generated by the DB)
Event_Description Event_Organiser Event_Date
A X 08.07.2014-10.07.2014
A X 15.07.2014
B Y 12.07.2014
Thank you for any suggestion
). I don't have Qlik at home to work with so it will be next Monday