Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Multiple Table comparision in Qlik View

Hi All,

I have three tables in qlikview as below

Table Name:Basic

Region Name
Person Name
Region APerson A
Region BPerson B

Table Name:Gold

Region Name
Person Name
Region APerson A
Region CPerson C

Table NameSmiley Tonguelatinum

Region Name
Person Name
Region APerson A
Region BPerson 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.

3 Replies

Re: Multiple Table comparision in Qlik View

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 ...

Highlighted

Re: Multiple Table comparision in Qlik View

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

Re: Multiple Table comparision in Qlik View

Hi,

See the attached sample file.

Regards,

Anand

Community Browser