topic Re: String Comparison in QlikView

String Comparison

mambi — Thu, 24 Apr 2014 14:31:02 GMT

Hi everyone,

in my project i want to compare 2 fields (load script); usually under sqlserver i use this functions : Levenshtein or Soundex

but in QV what are the equivalent ?,

i found this function metaphone simple to use ( no documentation )

Any idea ?

Re: String Comparison

Roop — Thu, 24 Apr 2014 14:39:33 GMT

I asked the same question a number of months ago and am still waiting for some kind of answer. I think that the only way in which to do anything like this is to use wildcards in a search (which is not the same at all).

On a list bar you can use the fuzzy search by right clicking on the list bar or typing "~"

Sorry not to help further

Re: String Comparison

swuehl — Sat, 26 Apr 2014 10:52:34 GMT

There are no built in functions in QV like those requested.

But if you search the forum, you might find some useful approaches (depending on your requirements):

Approximate String Matching in QlikView

string matching with fuzzy, trigram (n-gram), levenshtein, etc.

QlikView Vergleichsfunktion

(for a german style Soundex or implement the algorithm from en.wikipedia.org/wiki/Soundex )