topic Re: Max in Load Script in QlikView

Max in Load Script

jaarroyl — Wed, 09 May 2018 19:07:40 GMT

Hello, Please help to understand why this part of script says Invalid.

Regards

Invalid expression

LEFT JOIN (Filtro_Llamados)

ULTIMA_FECHA:

LOAD POLTIME,

If(FECHA_LLAMADO_POLIZA = 0, '0', Num(MAX(FECHA_LLAMADO_POLIZA),00)) as FECHA_ULTIMO_LLAMADO

Resident FECHA_LLAMADO

Group By POLTIME;

vishsaggi — Wed, 09 May 2018 19:12:30 GMT

Try this:

LEFT JOIN (Filtro_Llamados)

ULTIMA_FECHA:

LOAD POLTIME,

Num(Max(If(FECHA_LLAMADO_POLIZA = 0, '0', FECHA_LLAMADO_POLIZA)),00) as FECHA_ULTIMO_LLAMADO

Resident FECHA_LLAMADO

Group By POLTIME;

jaarroyl — Thu, 10 May 2018 17:30:43 GMT

Thanks!!!

It works.