topic Re: Maximum Date in QlikView

Maximum Date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Maximum Date

swuehl — Tue, 16 Jan 2018 23:00:14 GMT

Maybe something like

LOAD LEAD_ID,

Max( EXECUTION_DATE) as MaxDate

FROM ....

GROUP BY LEAD_ID;

Re: Maximum Date

vishsaggi — Tue, 16 Jan 2018 23:07:08 GMT

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;

Re: Maximum Date

Anonymous — Tue, 16 Jan 2018 23:23:14 GMT

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

Re: Maximum Date

vishsaggi — Tue, 16 Jan 2018 23:26:18 GMT

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

Re: Maximum Date

Anonymous — Tue, 16 Jan 2018 23:38:08 GMT

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

Re: Maximum Date

vishsaggi — Tue, 16 Jan 2018 23:40:32 GMT

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

Re: Maximum Date

swuehl — Tue, 16 Jan 2018 23:48:59 GMT

Then maybe

LOAD LEAD_ID,

Dayname(EXECUTION_DATE) as Date,

Max( EXECUTION_DATE) as MaxDate

FROM ....

GROUP BY LEAD_ID, Dayname(EXECUTION_DATE);

Re: Maximum Date

Anonymous — Wed, 17 Jan 2018 17:38:55 GMT

Thanks for the help, an apology the answer is correct

greetings