Discussion board where members can get started with QlikView.
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 expressionLEFT JOIN (MAIN)
SUM(AMOUNT)/Age_in_month AS AVG_COMM
GROUP BY ME_CODE,BR_CODE
did you try below
LEFT JOIN (MAIN)
SUM(AMOUNT)/max(Age_in_month) AS AVG_COMM
View solution in original post
Yes but same error comes in!
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
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.