topic Re: left join help in QlikView

left join help

Mon, 29 Apr 2013 14:49:04 GMT

hi all,

need help on below

tab1:

load

country,

value

from file1

left join

tab2:

load

country,

Re: left join help

shree909 — Mon, 29 Apr 2013 15:38:03 GMT

When u make a left join with Table 1 u wont get the null values.. As left join will get all the values from the table 1 and only matching values from the table 2.

or if u want to display all the null values with others use this before the script

Set NULLDISPLAY =Others;

Re: left join help

Mon, 29 Apr 2013 16:24:09 GMT

HI Shree,

please read my request

i am saying below:

table 1:

Country value

AU 10

IN 25

JP 20

table 2:

Country Categories

AU abc

IN xyz

now when i do left join between tables i get below values:

Country Value categories

AU 10 abc

IN 25 xyz

JP 20

for JP i want to replace blank with 'others'

can i do it in left join statement or i need to do some thing else

thanks

Re: left join help

shree909 — Mon, 29 Apr 2013 18:35:34 GMT

Hi ,

Please go through this

http://community.qlik.com/docs/DOC-3155