3 Replies Latest reply: Feb 19, 2013 3:47 AM by Anand Chouhan RSS

    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 Name:Platinum

       

      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.

        • Re: Multiple Table comparision in Qlik View
          Alessandro Saccone

          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
            Anand Chouhan

            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
              Anand Chouhan

              Hi,

               

              See the attached sample file.

               

              Regards,

              Anand