Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

SCRIPT ERROR

Dear Kush

Your script structure was applied & it is almost there but following script error coming while data is loaded. Please see what may causes this error?

Thanks for the reply

Invalid expression
LEFT JOIN (MAIN)

LOAD
BR_CODE,ME_CODE,

SUM(AMOUNT)/Age_in_month AS AVG_COMM

RESIDENT MAIN

GROUP BY ME_CODE,BR_CODE

1 Solution

Accepted Solutions
Kush
MVP
MVP

did you try below

LEFT JOIN (MAIN)

LOAD
BR_CODE,ME_CODE,

SUM(AMOUNT)/max(Age_in_month) AS AVG_COMM

RESIDENT MAIN

GROUP BY ME_CODE,BR_CODE

View solution in original post

4 Replies
Kush
MVP
MVP

did you try below

LEFT JOIN (MAIN)

LOAD
BR_CODE,ME_CODE,

SUM(AMOUNT)/max(Age_in_month) AS AVG_COMM

RESIDENT MAIN

GROUP BY ME_CODE,BR_CODE

View solution in original post

nevilledhamsiri
Specialist
Specialist
Author

Yes but same error comes in!

nevilledhamsiri
Specialist
Specialist
Author

This is right now. Small error from my end. If possible please let me know why Max is brought in front of the new field created.Once it is there only it is run with no errors.

Thank you very much

nevilledhamsiri
Specialist
Specialist
Author

We created a new field for Age in Months with today function. If we specify a specific date like 07/31/2020, how the string to be amended. 

Thanks