Good afternoon everyone,
We have an app that makes use of the Levenshtein algorithm (for all the curious: https://planetcalc.com/1721/ , this site gives you the description and examples with the calculator) and the reload works perfectly on Qlikview Desktop, but when I try to reload the app on QMC, it gives me the following error:
Error: Unexpected token: '(', expected one of: ',', ':', 'OPERATOR_PLUS', 'OPERATOR_MINUS', 'OPERATOR_MULTIPLICATION', 'OPERATOR_DIVISION', 'OPERATOR_STRING_CONCAT', ...
Does anyone know if there are any limitations with the use of such functions / algorithms?
This is the code where the error occurs:
LOAD
FxxFullname,
FxxLastName,
names,
HxxFullName,
HxxFirstName,
HxxLastName,
HxxWithoutFullName,
FxxFirstName,
if(LEVENSHTEIN(HxxFirstName,FxxFirstName)<=2,'true','false')
if(LEVENSHTEIN(HxxLastName,FxxLastName)<=2,'true','false')
if(WildMatch(replace(replace(HxxFullName,HxxFirstName,''),HxxLastName,''),'*' &names & '*'),'true','false')
(LEVENSHTEIN(HxxFirstName,FxxFirstName)/len(HxxFirstName))
(LEVENSHTEIN(HxxLastName,FxxLastName)/len(HxxLastName))
(LEVENSHTEIN(replace(replace(HxxFullName,HxxFirstName,''),HxxLastName,''),names)/(len(HxxFullName)))
Resident FxxList
Where not IsNull(names) and len(replace(names,' ',''))>0
We're using Qlikview 12.20.205 (November SR 4).
Thank you everyone!
