topic Re: Multiple Table comparision in Qlik View in QlikView

Multiple Table comparision in Qlik View

Tue, 19 Feb 2013 08:10:41 GMT

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.

Re: Multiple Table comparision in Qlik View

alexandros17 — Tue, 19 Feb 2013 08:32:00 GMT

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

its_anandrjs — Tue, 19 Feb 2013 08:41:02 GMT

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

its_anandrjs — Tue, 19 Feb 2013 08:47:59 GMT

Hi,

See the attached sample file.

Regards,

Anand