5 Replies Latest reply: Apr 16, 2018 2:26 AM by Aruna dabba RSS

    Default operation

    karthik reddy

      Hi,

      I have two tables in that two tables i have 2 records with same material id ,I know that in qlikview if i doesn't perform any operation between two tables it will perform outer join by default.But,here in this case if i give outer join(with command) it gives me one result and with out performing anything it gives me another result,can i know what is the action performing between the two tables by default.

        • Re: Default operation
          Aruna dabba

          hi,

          If u have two tables with one common field in both the tables qlikview automatically link the two table.

          • Re: Default operation
            Aiolos Zhao

            Hi karthik,

             

            Seems like in you sample, you are using right join, not outer join.

             

            And if you think it shows different when you outer join or do nothing, could you please give me some screens about your original table, and the different results screenshot of these situations?

             

            Thanks

            Aiolos

              • Re: Default operation
                karthik reddy

                op1.PNGop1sol.PNGop2.PNGop2sol.PNG

                Hi,

                why am i getting different results when iam performing default(sum(count=10))and outer join(sum(count=20)).

                  • Re: Default operation
                    Aiolos Zhao

                    Hi karthik,

                     

                    thanks, got it.

                    that's because if you use the outer join, it will do the Cartesian product between these 2 tables, so the data will double or triple.. but if you are not using the outer join, these 2 tables are independent, and only have the same key "Material id".


                    For your example,

                    you can see that, if you are not using outer join, you table will be :

                    Default operation.PNG

                     

                    Actually you only have 1 line of Count = 10 in back-end. Because you have 2 tables.

                     

                    if you use outer join, these 2 tables will merge into one table to do the join calculation. then you will only have 1 table in back-end :

                    Default operation_1.PNG

                     

                    You can see you have 2 lines of Count = 10

                     

                    That's the difference. Hope I have clarified.

                     

                    Thanks.

                    Aiolos

                    • Re: Default operation
                      Keerthika B

                      Hi karthik,

                      The join you have used is (right join) in your attached QVW. 

                       

                      Capture.PNG

                      Can you pls attach your xlsx file.

                       

                      keerthika