Only load eventdates less then maxdate for each post, loop?

Fri, 13 Jun 2014 08:44:18 GMT

I have a table with a field of eventdates (diffrent dates for diffrent persons) and a field of maxdate (also diffrent for diffrent persons). I want to only load those eventdates that occurs between min(eventdates) (that field also exist) and the maxdate for each person.

Should I use some sort of loop trought each persons eventdates against the persons maxdate or how to solve it?

I would also like to flag the second eventdate for each person.

Any suggestions are mostly appriated. Thank!

I have attached a qvd with sample data.

Re: Only load eventdates less then maxdate for each post, loop?

Gysbert_Wassenaar — Fri, 13 Jun 2014 08:52:03 GMT

Data:
LOAD EventDates,
    Id,
    MaxDate2,
    MinDate_EventDate
FROM  [comm121914.qvd] (qvd)
where EventDates < MaxDate2 and EventDates > MinDate_EventDate;

topic Re: Only load eventdates less then maxdate for each post, loop? in QlikView

Only load eventdates less then maxdate for each post, loop?

Re: Only load eventdates less then maxdate for each post, loop?