Discussion board where members can get started with QlikView.
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.
Any one please its urgent.
Thanks & Regards
Use the distinct keyword to load only unique records:
LOAD distinct pname,
Thanks no but i want to display Duplicate records with in 7 days plus and minus. Can you present any sample file.
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.