topic Re: Invalid Expression in QlikView

Invalid Expression

manoranjan_d — Thu, 19 May 2016 09:21:09 GMT

Details:

LOAD distinct

EMPDESG

MAX(DATE(CREATE_DATE_NUM,'MMDDYYYY')) asDATE_ID,

EMP_ID,

SAL

FROM

[XXX](qvd)

WHERE(IsNull(STATUS));

inner JOIN

Top5_project:

load distinct

EMP_ID,

TOP5_PROJECT,

EMP_DETAILS

FROM

[XXX](qvd)

i m getting invalid expression for the details table

Re: Invalid Expression

Anonymous — Thu, 19 May 2016 09:22:37 GMT

one FROM to much

inner JOIN

Top5_project:

load distinct

EMP_ID,

TOP5_PROJECT,

EMP_DETAILS

FROM

[XXX](qvd)

Re: Invalid Expression

manoranjan_d — Thu, 19 May 2016 09:28:55 GMT

its typo error its only one from

Re: Invalid Expression

manoranjan_d — Thu, 19 May 2016 09:30:07 GMT

Details:

LOAD distinct

EMPDESG

MAX(DATE(CREATE_DATE_NUM,'MMDDYYYY')) as DATE_ID,

EMP_ID,

SAL

FROM

[XXX](qvd)

WHERE(IsNull(STATUS));

inner JOIN

Top5_project:

load distinct

EMP_ID,

TOP5_PROJECT,

EMP_DETAILS

FROM

[XXX](qvd);

this is correct one but getting invlaid expression on MAX(DATE(CREATE_DATE_NUM,'MMDDYYYY')) as DATE_ID,

Re: Invalid Expression

PrashantSangle — Thu, 19 May 2016 09:31:13 GMT

max() is aggregated function need group by

Regards

Re: Invalid Expression

jagan — Thu, 19 May 2016 09:31:19 GMT

Hi,

You have to use Group by

Details:

LOAD distinct

EMPDESG

MAX(DATE(CREATE_DATE_NUM,'MMDDYYYY')) as DATE_ID,

EMP_ID,

SAL

FROM

[XXX](qvd)

WHERE(IsNull(STATUS))

GROUP BY EMPDESG, EMP_ID, SAL;

Hope this helps you.

Regards,

Jagan.

Re: Invalid Expression

Anonymous — Thu, 19 May 2016 09:31:44 GMT

more typo Errors? comma and asDATE_ID without space?

Details:

LOAD distinct

EMPDESG ,

MAX(DATE(CREATE_DATE_NUM,'MMDDYYYY')) as DATE_ID,

EMP_ID,

SAL

FROM

[XXX](qvd)

WHERE(IsNull(STATUS));

Re: Invalid Expression

PrashantSangle — Thu, 19 May 2016 09:33:36 GMT

Also max() convert date into number

so your final output is in number not in date

if want to convert it into date again then use

date(max(dateField),'DD/MM/YYYY')

Regards

Re: Invalid Expression

manoranjan_d — Thu, 19 May 2016 10:01:09 GMT

THANKS

Re: Invalid Expression

jagan — Thu, 19 May 2016 11:08:00 GMT

If you got the answer close this thread by giving correct and helpful answers to the posts which helps you in finding the answers.

Regards,

Jagan.