Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qw_johan
Creator
Creator

Avoid dubbles

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Find the attachment, hope this could help you.

Regards, tresesco

View solution in original post

3 Replies
tresesco
MVP
MVP

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

Regards, tresesco

tresesco
MVP
MVP

Find the attachment, hope this could help you.

Regards, tresesco

qw_johan
Creator
Creator
Author

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