Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qw_johan
Contributor

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
MVP
MVP

Avoid dubbles

Find the attachment, hope this could help you.

Regards, tresesco

3 Replies
MVP
MVP

Avoid dubbles

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

Regards, tresesco

MVP
MVP

Avoid dubbles

Find the attachment, hope this could help you.

Regards, tresesco

qw_johan
Contributor

Avoid dubbles

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

Community Browser