topic Avoid dubbles in QlikView https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302736#M1198517 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>A QlikView beginner here with a problem. I have two tables, one 'Persons' and another one 'Schedules'.</P><P>Most persons just have one matching schedule with dates (to and from) etc.<BR />But some people have several scheduels over the next couple of weeks or months, So they show up in my tablebox on multiple rows.</P><P>How do I avoid this? I just want people and their latest/newest schedule show up (the one with the latest dates).</P><P>I guess I have to loop through and see if a person has several schedules and then just pick the latest or newest.<BR />But I don't know how to do this. I need all the help I can get.</P><P>Thanks</P></BODY></HTML> Sun, 30 Jan 2011 17:59:15 GMT qw_johan 2011-01-30T17:59:15Z Avoid dubbles https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302736#M1198517 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>A QlikView beginner here with a problem. I have two tables, one 'Persons' and another one 'Schedules'.</P><P>Most persons just have one matching schedule with dates (to and from) etc.<BR />But some people have several scheduels over the next couple of weeks or months, So they show up in my tablebox on multiple rows.</P><P>How do I avoid this? I just want people and their latest/newest schedule show up (the one with the latest dates).</P><P>I guess I have to loop through and see if a person has several schedules and then just pick the latest or newest.<BR />But I don't know how to do this. I need all the help I can get.</P><P>Thanks</P></BODY></HTML> Sun, 30 Jan 2011 17:59:15 GMT https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302736#M1198517 qw_johan 2011-01-30T17:59:15Z Avoid dubbles https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302737#M1198518 <HTML><HEAD></HEAD><BODY><P>What are the fields you are having in the two tables? If possible upload a sample application.</P><P>Regards, tresesco</P></BODY></HTML> Mon, 31 Jan 2011 07:13:02 GMT https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302737#M1198518 tresB 2011-01-31T07:13:02Z Avoid dubbles https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302738#M1198519 <HTML><HEAD></HEAD><BODY><P>Find the attachment, hope this could help you.</P><P>Regards, tresesco</P></BODY></HTML> Mon, 31 Jan 2011 07:39:22 GMT https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302738#M1198519 tresB 2011-01-31T07:39:22Z Avoid dubbles https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302739#M1198520 <HTML><HEAD></HEAD><BODY><P>Thank you very much. Your file helped me to understand what I needed to do.</P></BODY></HTML> Mon, 31 Jan 2011 21:14:07 GMT https://community.qlik.com/t5/QlikView/Avoid-dubbles/m-p/302739#M1198520 qw_johan 2011-01-31T21:14:07Z