Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Max in Load Script

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;

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor III

Re: Max in Load Script

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;

View solution in original post

2 Replies
Highlighted
Esteemed Contributor III

Re: Max in Load Script

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;

View solution in original post

Highlighted
New Contributor III

Re: Max in Load Script

Thanks!!!

It works.