Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 :
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 :
You can see you have 2 lines of Count = 10
That's the difference. Hope I have clarified.
Thanks.
Aiolos
hi,
If u have two tables with one common field in both the tables qlikview automatically link the two table.
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
Hi,
why am i getting different results when iam performing default(sum(count=10))and outer join(sum(count=20)).
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 :
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 :
You can see you have 2 lines of Count = 10
That's the difference. Hope I have clarified.
Thanks.
Aiolos
Hi karthik,
The join you have used is (right join) in your attached QVW.
Can you pls attach your xlsx file.
keerthika