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 data for within 7 days

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

Tags (1)
4 Replies
Not applicable

Re: Duplicate data for within 7 days

Any one please its urgent.

Thanks & Regards

MVP & Luminary
MVP & Luminary

Re: Duplicate data for within 7 days

Use the distinct keyword to load only unique records:

LOAD distinct pname,

     [Issuance Date],

     [Departure Date],

     TNo,

     [Mobile No],

     [E-Mail ID]

FROM ...etc;


talk is cheap, supply exceeds demand
Not applicable

Re: Duplicate data for within 7 days

Hi,

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

Thanks

Not applicable

Re: Duplicate data for within 7 days

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

Community Browser