2 Replies Latest reply: Jun 22, 2016 11:52 AM by Jagveer Dhillon RSS

    Left Join in Qlikview

    Jagveer Dhillon

      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.

       

      Salesforce.JPG