Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Duplicate checking

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

3 Replies
jsn
Honored Contributor

Re: Duplicate checking

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.

Not applicable

Re: Duplicate checking

Hi,

Do you present any sample for this.

Thanks

Not applicable

Re: Duplicate checking

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

Thanks

Community Browser