Max and Min dates in Resident Load

dseelam — Fri, 17 Jan 2014 23:11:29 GMT

Hello everyone,

I need a help!

I Have a table with 4 different date fields with different dates it has warranty start date, end date and contract start, end dates

so total of 4 dates I need Max of Warranty End(marked in red) and Min Contract Start (marked in red) which is possible through resident load

but when ever I reload it I am getting duplicates in my straight table when I analyse data came to know it is pulling max warranty end and min contract start but pulling all the dates from warranty start and contract end which is wrong

Output should should be only max warranty end date with corresponding warranty start and min contract start date with corresponding contract end

where I don't need min or max for warranty start and contract end I need only corresponding dates.

Example:

ID	WARRANTY START	WARRANTY END	CONTRACT START	CONTRACT END	COUNT
1	01/01/2012	01/01/2013	01/02/2013	01/02/2014	1
2	01/01/2012	01/01/2013	01/01/2013	01/02/2014	1
3	01/02/2012	01/01/2013	10/02/2012	01/02/2014	0
4	-	-	-	-	1
5	01/02/2012	01/02/2013	05/05/2014	01/09/2017	1

Guys please help me thanks in advance

This is what I am using

MaxWarranty_10:

LOAD

ID,

Max(Warrantydate) AS [WARR END]

RESIDENT Warrantys

Group BY ID;

MinContract:

LOAD

SID,

Min([Contracts.START_DATE]) AS [CONTRACT START]

Resident Warrantys

Group BY SID;

topic Max and Min dates in Resident Load in QlikView

Max and Min dates in Resident Load