Why qlik don't know year and LEFT function

[taz803]

hello team

this is my request : YEAR(LEFT(mois_obs,4))-5 as year_test

i have this error msg from qliksense :

Connector reply error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: "YEAR" : invalid identifier 

and even i delete year the msg come : 

Connector reply error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00904: "LEFT" : invalid identifier 

how can i handle it

[Lokesh_5045]

Left function returns string. try using num or num# functions instead year. Assign it to year_test.

For instance, num(Left(String, 4)).

[Or]

This is not related to Qlik. You are getting an error message from your connection to the database, presumably due to incorrect usage of functions in an SQL query.

[taz803]

i changed for : 

cast(YEAR(LEFT(mois_obs,4))-5 as varchar) as year_test

Connector reply error: ErrorSource: OraOLEDB, ErrorMsg: ORA-00906: missing left parenthesis

[Lokesh_5045]

Thank you @Or . I overlooked the error message regarding connector error.