Multiple Table comparision in Qlik View

[#1]

Hi All,

I have three tables in qlikview as below

Table Name:Basic

Region Name	Person Name
Region A	Person A
Region B	Person B

Table Name:Gold

Region Name	Person Name
Region A	Person A
Region C	Person C

Table Name:Platinum

Region Name	Person Name
Region A	Person A
Region B	Person B

Now I need to join all the three tables in qlikview and tell how many people have changed from Basic to Gold or Platinum. Note here change I mean is if the Person has entry both in basic table and Gold Table then he has changed from basic to gold etc. Please suggest is it possible in qlikview.

[alexandros17]

Add a column to each table in order to distinguish the type so

Basic will be

Region           Person           typebasic

Region A         Person A      'B'

and so on for the other tables.

Then join all the tables in order to have a unique table with columns:

Region, Person, typebasic, typegold, typeplatinum

al last reload this table checking with if condition if a person has values in more than a column "type"

It has to work ...

[its_anandrjs]

Hi,

Load your table some thing like this

load * inline

[

RegionName,  PersonName, Type

Region A,    Person A,         Basic

Region B,    Person B,         Basic

];

load * inline

[

RegionName,    PersonName, Type

Region A,    Person A,            Gold

Region C,    Person C,            Gold

];

load * Inline

[

RegionName,    PersonName,Type

Region A,    Person A,           Platinum

Region B,    Person B,           Platinum

];

and take a straight table and in the dimension use RegionName, PersonName and

Expression use if(Count(Type)>1,Count(Type))

to check duplicates and repeative records.

HTH

Regards,

Anand

[its_anandrjs]

Hi,

See the attached sample file.

Regards,

Anand