How to only load the first date

pernillet — Mon, 22 Jul 2013 20:30:49 GMT

I have a Date called D3_Recognition date, and I only want the lowes date in the database for each distinct D3_JH key. Can anyone tell my, why I load more than one value for the date per key?

$(QVD_Name)_TMP:

//first 1000

LOAD

    "D3_RecognitionDate",

    "D3_JH";

SQL SELECT

    "D3_RecognitionDate",

    "D3_JH"

    FROM databasename.databasenamejohndo A

    group by D3_JH, D3_RecognitionDate

    having "D3_RecognitionDate" = (select min("D3_RecognitionDate") FROM databasename.2 B where B.D3_JH = A.D3_JH group by D3_JH )

;

Re: How to only load the first date

Anonymous — Mon, 22 Jul 2013 20:35:24 GMT

This should work for you:

LOAD

"D3_RecognitionDate",

"D3_JH";

SQL SELECT

min("D3_RecognitionDate") as "D3_RecognitionDate",

"D3_JH"

FROM databasename.databasenamejohndo A

group by D3_JH

topic Re: How to only load the first date in QlikView

How to only load the first date

Re: How to only load the first date