topic Comparison of string in Qlikview in QlikView

Comparison of string in Qlikview

Thu, 29 Aug 2013 06:06:03 GMT

Hi All,

Can any one tell how to compare two strings and provide the count based on matching?

For Example:

String are:

South Africa

South Afri

Count is 10(including space)

Re: Comparison of string in Qlikview

jagan — Thu, 29 Aug 2013 06:11:38 GMT

Hi,

If('South Africa' = 'South Afri', 'Match', 'Not Match')

Len() is used to find the length of the string.

Regards,

Jagan.

Re: Comparison of string in Qlikview

tresB — Thu, 29 Aug 2013 06:16:03 GMT

This?

If(left('South Africa', Len('South Afri')) = 'South Afri', Len('South Afri' )) // here you can replace the strings accordingly

If not this, plesae expain a bit more.

Re: Comparison of string in Qlikview

Thu, 29 Aug 2013 06:16:07 GMT

Thanks Jehan,

But i want to compare two column of data which are having string data and give the count value for each row of data

Re: Comparison of string in Qlikview

Thu, 29 Aug 2013 06:24:48 GMT

My input are like as follows:

String1	String2
Samsung	Samsun
China	Chinna

I want to get the count based on number of characters are matching.

like as follows:

String1	String2	Count
Samsung	Samsun	6
China	Chinna	4

Re: Comparison of string in Qlikview

tresB — Thu, 29 Aug 2013 07:36:23 GMT

That means you need to some function which would give the first mismatch chracter position. QV doest not have a function for that. I guess you can try creating a vb function and call that in the script.

Re: Comparison of string in Qlikview

jfkinspari — Thu, 29 Aug 2013 07:43:06 GMT

If the length of the fields are relatively small, you you could make embedded if formulas comparing the first character in first level if, two characters in second level if .. undtil you reach the maximum string size.

Not pretty - but it might be a solution.

Re: Re: Comparison of string in Qlikview

jagan — Thu, 29 Aug 2013 08:13:04 GMT

Hi,

Please find attached file for solution, used macro to solve this.

Regards,

Jagan.

Re: Comparison of string in Qlikview

tresB — Thu, 29 Aug 2013 08:15:28 GMT

Hello,

I have created a function in VB and implemented that during load. Happy to try it and achieving.

Hope it helps.

PFA

Re: Comparison of string in Qlikview

Thu, 29 Aug 2013 08:41:37 GMT

use this expression in your script

If(left(String1, Len(String2)) = String2, Len(String2 )) As Count

Re: Comparison of string in Qlikview

Mon, 02 Sep 2013 06:57:19 GMT

Thanks Jahan,

It works fine.

Re: Comparison of string in Qlikview

Mon, 02 Sep 2013 06:58:10 GMT

Thanks tresesco,

Its works fine