topic Re: Join Condition in QlikView

Join Condition

NavinReddy — Tue, 04 Jun 2013 08:26:09 GMT

Hi All,

im get confused help some one

Dimention Transparent

product county

A BNG

B DL

C MB

D KL

Dimention to transparent or transparent to dimension

which is the better Display option by using join condition

Thanks & Regards

Niranjan

Re: Join Condition

sujeetsingh — Tue, 04 Jun 2013 08:29:59 GMT

Niranjan i am not able to get it .

What you are joining?

Re: Join Condition

NavinReddy — Tue, 04 Jun 2013 09:11:27 GMT

Hi Sardar,

Those are Two tables Dimention,Transparent

While joining these two tables which is better way to join

leftjoin or rightjoin (and why )

could you plz explain

Thanks & Regards

Niranjan

Re: Join Condition

er_mohit — Tue, 04 Jun 2013 09:12:34 GMT

I think

if you have 1000 records in dimenson and less records in transparent then most probably do left if vice versa then right

if you want to keep records oon the basis of dimension tab and doesnt wnt to join

then use left keep

or vice versa then right keep

hope it helps

Re: Join Condition

sujeetsingh — Tue, 04 Jun 2013 09:18:35 GMT

Niranjan first of all you have a common key for joining in both table .

You can use joins based on what you want and density of your data in both table.

You can try concatenate too.

So first get all stuffs of requirement to be implemented.

Re: Join Condition

narender123 — Tue, 04 Jun 2013 09:22:13 GMT

Hi,

take the master table 1st and then left join 2nd table with 1st.

Or you make the outer join by taking one similar column in both table and other columns which are same in both table,rename them. and for this you dont need to write left or right join between these tables.

Thanks

Narender

Re: Join Condition

Joaquin_Lazaro — Tue, 04 Jun 2013 09:42:09 GMT

HI niranjan123

This document contains an example of all the possible joins with QV.

Please, review the document and then use the best join to get the result that you need on every qvw.