Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
karthikchintu30
Contributor
Contributor

Default operation

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.

1 Solution

Accepted Solutions
uacg0009
Partner - Specialist
Partner - Specialist

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

View solution in original post

5 Replies
Anonymous
Not applicable

hi,

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

uacg0009
Partner - Specialist
Partner - Specialist

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

karthikchintu30
Contributor
Contributor
Author

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)).

uacg0009
Partner - Specialist
Partner - Specialist

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

keerthika
Creator II
Creator II

Hi karthik,

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

Capture.PNG

Can you pls attach your xlsx file.

keerthika