topic Re: levenshtein in Qliksense in App Development

levenshtein in Qliksense

Anonymous — Wed, 03 Jan 2018 19:17:15 GMT

Good Morning,

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

Thks for help your.

Re: levenshtein in Qliksense

marcus_sommer — Mon, 08 Jan 2018 11:55:38 GMT

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

- Marcus

Re: levenshtein in Qliksense

Anonymous — Fri, 12 Jan 2018 21:06:24 GMT

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

Re: levenshtein in Qliksense

silva_robertool — Fri, 12 Jan 2018 21:58:25 GMT

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

Re: levenshtein in Qliksense

tomasz_tru — Sat, 13 Jan 2018 10:26:23 GMT

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

Re: levenshtein in Qliksense

silva_robertool — Tue, 29 May 2018 13:08:54 GMT

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.

Re: levenshtein in Qliksense

AlexOmetis — Wed, 22 Aug 2018 15:49:51 GMT

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.