Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Maybe something like
LOAD LEAD_ID,
Max( EXECUTION_DATE) as MaxDate
FROM ....
GROUP BY LEAD_ID;
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;
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
Did you try the code i pasted in my earlier reply?
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
Did not get you can you elaborate and send some screenshots of what your expected output is?
Then maybe
LOAD LEAD_ID,
Dayname(EXECUTION_DATE) as Date,
Max( EXECUTION_DATE) as MaxDate
FROM ....
GROUP BY LEAD_ID, Dayname(EXECUTION_DATE);
Thanks for the help, an apology the answer is correct
greetings