Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

left join help

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

3 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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;

Not applicable
Author

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
Partner - Specialist II
Partner - Specialist II

Hi ,

Please go through this

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