levenshtein in Qliksense

[Anonymous]

Good Morning,

You need to calculate the distance between two strings of characters by means of the levenshtein algorithm.

Thks for help your.

[marcus_sommer]

I think this will be helpful: Re: How to merge/combine multiple slices of a pie chart into one slice/category?

- Marcus

[Anonymous]

Thanks for your help, but this post is in Qlikview; I am needing in Qliksense!

[silva_robertool]

Maybe a make a function on database and realise the processing on data extract; Other solution is make a function for levensthein algorithm in a calculed column with sense sintax language and use on yours reports.

Levenshtein distance - Wikipedia

I wait help you, bye

[tomasz_tru]

I think it's best to do it on source database level or in the script. What kind of analysis do you want to perform a (I'm just curious)?

Tomasz

[silva_robertool]

I think it's best to do it on source database level, why various database use native implementation of levensthein algorithm, for example Oracle database.  But in performance question, make an test for see a best option.

Regards, Roberto.

[AlexOmetis]

There is an undocumented function for this in Qlik Sense - LevenshteinDist - that was introduced in the June 2017 release. The only place you can find reference to it is in the API explorer: https://api-insights.qlik.com/‌. I've tested it and can validate it does work, even though it's not documented.