Max and Min Dates In Resident Load

dseelam — Fri, 17 Jan 2014 23:20:11 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;

Re: Max and Min Dates In Resident Load

Gysbert_Wassenaar — Sat, 18 Jan 2014 07:52:04 GMT

Can you post an example document with sample data? It's not clear to me what's the problem. A set of source data and an example result table would help.

Re: Max and Min Dates In Resident Load

nizamsha — Sat, 18 Jan 2014 08:09:19 GMT

post some EG data

Re: Max and Min Dates In Resident Load

gopalopsharma — Sat, 18 Jan 2014 09:19:27 GMT

Hello Dinesh,

remove the Group By statement and also the ID from load.

It should help.

topic Re: Max and Min Dates In Resident Load in QlikView

Max and Min Dates In Resident Load

Re: Max and Min Dates In Resident Load

Re: Max and Min Dates In Resident Load

Re: Max and Min Dates In Resident Load