Duplicates when using Resident Table

Wed, 14 May 2014 15:54:42 GMT

Hi,

I need some help. I am trying to create a qvd to displays call metrics. This takes in 2 spreadsheets from disparate sources. One of the spreadsheets does not have the closed date populated so I am using an If(IsNull etc.. to populate with todays date. No problems on that bit.

I then need to calculate the number of days between start and finish and for this I use the Ceil function num(date) - num(date) etc. No problems with this either.

I then add a banding field (pretty standard if days between etc). This banding also exists in the very first load as well.

My problem is that on reload I get duplicates not from the data where I have calculated dates date but from the clean data in the first load. This does not occur for every record. I also know that it is from this data source because the data in the Call No is different, in on e table the cals start PHD and in the second INC

Script posted below

My duplicate data looks like

Call No Days Days Band

1 4 0-5 Days

1 - 0-5 Days

Any help gratefully appreciated

topic Duplicates when using Resident Table in QlikView

Duplicates when using Resident Table