Avoid dubbles

[qw_johan]

Hi everybody!

A QlikView beginner here with a problem. I have two tables, one 'Persons' and another one 'Schedules'.

Most persons just have one matching schedule with dates (to and from) etc.
But some people have several scheduels over the next couple of weeks or months, So they show up in my tablebox on multiple rows.

How do I avoid this? I just want people and their latest/newest schedule show up (the one with the latest dates).

I guess I have to loop through and see if a person has several schedules and then just pick the latest or newest.
But I don't know how to do this. I need all the help I can get.

Thanks

[tresB]

What are the fields you are having in the two tables? If possible upload a sample application.

Regards, tresesco

[tresB · Accepted solution]

Find the attachment, hope this could help you.

Regards, tresesco

[qw_johan]

Thank you very much. Your file helped me to understand what I needed to do.