Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

karthikchintu30
New 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
Valued Contributor

Re: Default operation

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

5 Replies
arunaerra
Contributor

Re: Default operation

hi,

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

uacg0009
Valued Contributor

Re: Default operation

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
New Contributor

Re: Default operation

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
Valued Contributor

Re: Default operation

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
Contributor II

Re: Default operation

Hi karthik,

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

Capture.PNG

Can you pls attach your xlsx file.

keerthika

Community Browser