left join help

[#1]

hi all,

need help on below

tab1:

load

country,

value

from file1

left join

tab2:

load

country,

category

from file2

in this case, if country in tab1 is not present in tab2, it shows '-' in category column in dashboard. i want to write 'if function' in tab2 on category column see below:

tab1:

load

country,

value

from file1

left join

tab2:

load

country,

if(country = null(), 'Others', category) as Category

from file2

but its not working

please advise

[shree909]

Hi

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;

[#3]

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

[shree909]

Hi ,

Please go through this

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