Left Join in Qlikview

[#1]

Hi,

I have the data sources as shown below. I am getting this data from salesforce, so that is another problem, but here is what i need

I have a Salesman table listing all salesmen, an account table, listing all accounts associated with the salesmen. the third table is activity table which list if there was any meeting or call with an account.

I want to create an activity tracker which lists the activity of an account (meeting or call), but if there is none still i want to list that account with activity shown as 0.

[Gysbert_Wassenaar]

A bit of messing about with the Suppress Zero-Values and/or Suppress Missing options should do the trick. Can you post a small qlikview document with example data? I'm to lazy to type over the information in the screenshot.

[#3]

I got it, using Left Join in the script. Thanks anyway