Maximum Date

[Anonymous]

Good afternoon

I would like to help me I have a problem I want to know the field that I have marked in yellow which is the maximum date field marked with red in theory my result is the one found in blue

All this I want to do from the script but I have no idea what the function I should use to do so I hope you can help me thank you very much

Annex the Excel with which I am doing my tests so attached an image in which I put a small description of what I need

greetings

Luis Espinoza

[swuehl]

Maybe something like

LOAD LEAD_ID,

          Max( EXECUTION_DATE) as MaxDate

FROM ....

GROUP BY LEAD_ID;

[vishsaggi · Accepted solution]

What is that you are expecting in Qlikview and how did you come to this output that you want 13/09/2017 date?

Are you looking for this?

IF YES, then use like below:

Pureba:

LOAD CAMPAIGNCODE_CAMP,

     LEAD_ID,

     FECHA_EJECUCION,

     FECHA_RESPUESTA,

     RESPONSECODE2,

     DESCRIPTION,

     DESCRIPCION,

     CANAL,

     EXECUTION_DATE

FROM

Prueba.xls

(biff, embedded labels, table is Hoja1$);

LEFT JOIN(Pureba)

Load CAMPAIGNCODE_CAMP,

     LEAD_ID,

     Date(Max(EXECUTION_DATE), 'DD/MM/YYYY hh:mm:ss') AS MaxDate

Resident Pureba

Group By CAMPAIGNCODE_CAMP, LEAD_ID;

[Anonymous]

I want a final date per day regardless of the field LEAD_ID for example the LEAD_ID has a number of dates (many days) I want every day me the maximum date I hope I can explain

[vishsaggi]

Did you try the code i pasted in my earlier reply?

[Anonymous]

If you try but give me the maximum date of the LED_ID and I want the maximum date per day of the LED_ID

[vishsaggi]

Did not get you can you elaborate and send some screenshots of what your expected output is?

[swuehl]

Then maybe

LOAD LEAD_ID,

          Dayname(EXECUTION_DATE) as Date,

          Max( EXECUTION_DATE) as MaxDate

FROM ....

GROUP BY LEAD_ID, Dayname(EXECUTION_DATE);

[Anonymous]

Thanks for the help, an apology the answer is correct

greetings