topic Duplicate data for within 7 days in QlikView

Duplicate data for within 7 days

Thu, 27 Dec 2012 06:27:46 GMT

Hi All,

I have to show Duplicate records and data which is comes under with in 7 days like in sample pname = B is comes within 7 days like min date is 2012-11-11 and max date is 2012-11-17.

Thanks

Re: Duplicate data for within 7 days

Thu, 27 Dec 2012 07:18:29 GMT

Any one please its urgent.

Thanks & Regards

Re: Duplicate data for within 7 days

Gysbert_Wassenaar — Thu, 27 Dec 2012 13:46:44 GMT

Use the distinct keyword to load only unique records:

LOAD distinct pname,

[Issuance Date],

[Departure Date],

TNo,

[Mobile No],

[E-Mail ID]

FROM ...etc;

Re: Duplicate data for within 7 days

Thu, 27 Dec 2012 14:48:54 GMT

Hi,

Thanks no but i want to display Duplicate records with in 7 days plus and minus. Can you present any sample file.

Thanks

Re: Duplicate data for within 7 days

Thu, 27 Dec 2012 14:51:52 GMT

Hi,

I provide you new sample excel file where i have to display duplicate records like in yellow background and column in green sholud match exactly in a rows.

Thanks