topic Re: Left Join in Qlikview in QlikView

Left Join in Qlikview

Wed, 22 Jun 2016 14:30:22 GMT

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.

Re: Left Join in Qlikview

Gysbert_Wassenaar — Wed, 22 Jun 2016 15:33:23 GMT

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.

Re: Left Join in Qlikview

Wed, 22 Jun 2016 15:52:09 GMT

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