Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
fredericobarrac
Partner - Contributor III
Partner - Contributor III

Levenshtein - QMC Reload vs Desktop Reload

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!

0 Replies