3 Replies Latest reply: Jan 31, 2011 4:14 PM by Johan Adolfsson RSS

    Avoid dubbles

    Johan Adolfsson

      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