topic Re: Default operation in QlikView

Default operation

karthikchintu30 — Wed, 25 Nov 2020 16:16:04 GMT

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

Anonymous — Mon, 16 Apr 2018 06:26:39 GMT

hi,

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

Re: Default operation

uacg0009 — Mon, 16 Apr 2018 06:26:46 GMT

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

karthikchintu30 — Mon, 16 Apr 2018 07:21:32 GMT

Hi,

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

Re: Default operation

uacg0009 — Mon, 16 Apr 2018 07:34:25 GMT

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

Re: Default operation

keerthika — Mon, 16 Apr 2018 07:36:42 GMT

Hi karthik,

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

Can you pls attach your xlsx file.

keerthika