topic Duplicate checking in QlikView

Duplicate checking

Wed, 26 Dec 2012 09:07:09 GMT

Hi,

i have do check duplicate records but condition for with in 7 days

like ex1

Issuedate, TicketNo,Cname

26/12/2012,T1,Johan

27/12/2012,T2,Johan

28/12/2012,T3,Johan

29/12/2012,T4,Johan

30/12/2012,T5,Johan

31/12/2012,T6,Johan

01/12/2012,T7,Johan

ex2

Issuedate, TicketNo,Cname

26/12/2012,T1,Rj

27/12/2012,T2,Rj

28/12/2012,T3,Rj

29/12/2012,T4,Rj

30/12/2012,T5,Rj

31/12/2012,T6,Rj

01/12/2012,T7,Rj

02/12/2012,T8,Rj

for ex1 we have to check ticket generation but for ex2 we dont need to check because there is greater then 7 Issuedate

please help for this.

Thanks

Anonymous — Wed, 26 Dec 2012 09:13:54 GMT

Hm, I don't see any duplicate records...

But, you can load everything except the last 7 days, and then load the last 7 days, distinct, and combine the two data sets.

Wed, 26 Dec 2012 09:50:04 GMT

Hi,

Do you present any sample for this.

Thanks

Wed, 26 Dec 2012 09:54:10 GMT

And i want to create a straight table or pivot table for this.

Thanks