topic Re: duplication in interval match in QlikView

duplication in interval match

rcandeo — Wed, 11 Dec 2013 19:53:16 GMT

Hi, in this aplication I have a duplication as you can see in the dinamic table. There should be 3 lines and shows me 6.

Anyone can explain me why and how to solve this please?

Re: duplication in interval match

rcandeo — Fri, 24 Jan 2014 10:01:05 GMT

Hi Everybody. Maybe someone can help with this today? I still have this duplication.

Re: duplication in interval match

Fri, 24 Jan 2014 10:18:17 GMT

Hi,

In your selection, workers A and B have exactly the same times and the are 3 lot numbers meeting the interval match, so for worker names and lots together you get 6 valid entries.

To get only 3, you'd need an additional condition to match worker name and lot.

Hth

Re: duplication in interval match

rcandeo — Fri, 24 Jan 2014 11:05:42 GMT

Thank You. Unfortunatelly I have the same dates for more than a worker. I was thinking that could have some trick to get the data without this duplication. I think I´ll agroup all data at the final of my script to solve the problem.