topic Re: Compare Match in QlikView

?

xyz1 — Sun, 14 Apr 2019 14:35:03 GMT

tresB — Fri, 05 May 2017 11:27:47 GMT

Are you trying to get the output in front-end (may be in a text box)? Is your comparison case sensitive?

xyz1 — Sun, 14 Apr 2019 14:36:01 GMT

tresB — Fri, 05 May 2017 12:28:08 GMT

Try expression like:

For case INsensitive match (in text box)

='All match : ' & If(not Max(upper(Name)=upper(Name2)), 'NO', 'YES')

Case sensitive

='All match : ' & If(not Max(Name=Name2), 'NO', 'YES')

To get the list of names:

='Not Matched Name : ' & Concat( Distinct If(not Name=Name2, Name), ',')

='Not Matched Name2 : ' & Concat( Distinct If(not Name=Name2, Name2), ',')

If you need case insensitive result, just use upper()/lower() like shown above.

xyz1 — Sun, 14 Apr 2019 14:36:30 GMT

Anonymous — Tue, 09 May 2017 04:48:18 GMT

Is there any relation between two tables that you are loading?? If not, i think we should create one and then replace

Name and Name2 with Assetname and Item .