topic Re: Match on multiple fields without synthetic key in QlikView

Match on multiple fields without synthetic key

Thu, 03 Jul 2014 02:00:58 GMT

Two different tables. Here is an example...

Table1:

Field1, Field2, Field3

Smith, Bob, Austin

Jones, Sally, San Diego

Table2: (note different field names)

FieldA , FieldB, FieldC

Jones, Bob, Cincinnati

Smith, Sally, San Diego

I'd like to display in a straight table or chart, all records where "Field1=FieldA AND Field2=FieldB AND Field3=FieldC". There are actually 10 fields that need to match so using a synthetic key is not possible. I've attempted with Set Analysis but can't seem to get the right combination. Flexible on the approach but I eventually need to narrow my result set down to the records that meet all of the criteria above and most importantly, I don't want to select the criteria one field at a time.

Thoughts?

Re: Match on multiple fields without synthetic key

Thu, 03 Jul 2014 02:04:06 GMT

you can explore indirect set analysis.

Field1=..... p(FieldA)

Re: Match on multiple fields without synthetic key

Thu, 03 Jul 2014 02:07:41 GMT

Can you elaborate please? I tried this approach but it gave me ALL possible values of FieldA and not the ones that matched Field1. So it was ...

Field1=Jones, FieldA=Jones, FieldA=Smith

I need only ... Field1=Jones,FieldA=Jones

Re: Match on multiple fields without synthetic key

Thu, 03 Jul 2014 02:10:12 GMT

Have a look at this discussion, that should give you a good idea.

How to compare 2 fields using SET ANALYSIS ?

Re: Match on multiple fields without synthetic key

Thu, 03 Jul 2014 02:45:14 GMT

Thanks but I found the same discussion earlier and it didn't help. The correct answer was never identified and he is having the exact same problem I am still. I'm posting here as a last resort from not being able to locate a solution on my own.

Again, I need a 1 to 1 match on multiple fields across two tables ...

Field1 = FieldA AND Field2 = FieldB AND Field3 = FieldC