Levenshtein - QMC Reload vs Desktop Reload

fredericobarrac — Wed, 09 May 2018 12:20:16 GMT

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!

topic Levenshtein - QMC Reload vs Desktop Reload in QlikView

Levenshtein - QMC Reload vs Desktop Reload