Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 ...

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