Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ...
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
Hi,
See the attached sample file.
Regards,
Anand