topic Re: Invalid Expression attempting to get MaxDate in QlikView

Invalid Expression attempting to get MaxDate

Thu, 26 Jun 2014 17:59:01 GMT

[Loss Mit Steps 324]:

LOAD [Loan Number] as ln_no_324,

[Ls Step Code] as step_cd_324,
Max([Ls Actual Completion Date]) as s324_Dt,
[Record Change Code]
FROM
(qvd)
where match([Ls Step Code],'324')
and match([Record Change Code],'A','C')
group by [Loan Number]

I am attempting to show the maxdate and row for a table. The issue is the table tends to have duplicate or repeating fields. I keep getting Invalid expression however when I debug it does not pinpoint exactly where the invalid expression occurs.

Re: Invalid Expression attempting to get MaxDate

maxgro — Thu, 26 Jun 2014 18:56:38 GMT

you have to group by all fields where there isn't an aggregation function; added in bold

[Loss Mit Steps 324]:

LOAD

[Loan Number] as ln_no_324,

[Ls Step Code] as step_cd_324,
Max([Ls Actual Completion Date]) as s324_Dt,
[Record Change Code]
FROM
(qvd)
where match([Ls Step Code],'324')
and match([Record Change Code],'A','C')
group by

[Loan Number],

[Ls Step Code],

[Record Change Code]

Re: Invalid Expression attempting to get MaxDate

PrashantSangle — Sat, 28 Jun 2014 06:54:33 GMT

Hi,

Yes it will through you error for Group By clause.

Instead of using only [Loan Number]

you have to use all the fields excluding those fields on which you are using aggregate function .

Regards,