Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jaarroyl
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
vishsaggi
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;

2 Replies
vishsaggi
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;

Highlighted
jaarroyl
New Contributor III

Re: Max in Load Script

Thanks!!!

It works.