topic Invalid Expression Error in QlikView

Invalid Expression Error

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

Hi,

Please can someone assist in identifying what I am doing wrong. The error message says that it is an invalid expression. It happens when i add the "MAX" command infront of the date. Example of date = 30.05.201615:26:26

Code below :

TASKS:

LOAD PROCTY,

TRART,

PROCS,

TOSTAT,

MAX(timestamp(timestamp#(CONFIRMED_AT,'DD.MM.YYYYhh:mm:ss'),'YYYY/MM/DD hh:mm:ss')),

VLENR,

NLTYP

FROM

[..\..\ORDIM_C.QVD]

(qvd)

WHERE VLENR <> ' '

AND PROCTY = 2015

AND TOSTAT = 'C'

AND NLTYP = 9025;

Re: Invalid Expression Error

PrashantSangle — Mon, 27 Jun 2016 09:10:22 GMT

Hi,

max() is aggreagated function.

You need group by clause

try like

TASKS:

LOAD PROCTY,

TRART,

PROCS,

TOSTAT,

MAX(timestamp(timestamp#(CONFIRMED_AT,'DD.MM.YYYYhh:mm:ss'),'YYYY/MM/DD hh:mm:ss')),

VLENR,

NLTYP

FROM

[..\..\ORDIM_C.QVD]

(qvd)

WHERE VLENR <> ' '

AND PROCTY = 2015

AND TOSTAT = 'C'

AND NLTYP = 9025

group by

PROCTY,

TRART,

PROCS,

TOSTAT,

VLENR,

NLTYP;

Regards

Re: Invalid Expression Error

vcanale — Mon, 27 Jun 2016 14:57:14 GMT

Hi,

MAX() is an aggr function..
try with a "group by" for the fields not used in the Max().

eg: Group by (Aggr in script)