topic Using same field from different tables in QlikView https://community.qlik.com/t5/QlikView/Using-same-field-from-different-tables/m-p/377335#M140694 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>We are pulling in Salesforce Lead and Contact data into Qlikview but essentially we want to report on this as 1 table. For example we want to know the total number of leads and contacts created in a particular month. I have am using the expression:</P><P></P><P>=Count (distinct ContactId) + Count (DISTINCT LeadId)</P><P></P><P>in a graph but what dimension can I use to have it ordered by created date. I have tried a dimension with the expression:</P><P></P><P>=if(isnull(monthname(ContactCreatedDate)), monthname(LeadCreatedDate), monthname(ContactCreatedDate))</P><P></P><P>But when I drill down on the chart by created month it only pulls those records with both fields populated; LeadCreatedDate &amp; ContactCreatedDate (i.e. converted leads).</P><P></P><P>Is there a way to combine 2 fields from seperate tables or should this be done in the Load script?</P><P></P><P>Thanks</P><P>Jon</P></BODY></HTML> Mon, 13 Aug 2012 12:05:49 GMT 2012-08-13T12:05:49Z Using same field from different tables https://community.qlik.com/t5/QlikView/Using-same-field-from-different-tables/m-p/377335#M140694 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>We are pulling in Salesforce Lead and Contact data into Qlikview but essentially we want to report on this as 1 table. For example we want to know the total number of leads and contacts created in a particular month. I have am using the expression:</P><P></P><P>=Count (distinct ContactId) + Count (DISTINCT LeadId)</P><P></P><P>in a graph but what dimension can I use to have it ordered by created date. I have tried a dimension with the expression:</P><P></P><P>=if(isnull(monthname(ContactCreatedDate)), monthname(LeadCreatedDate), monthname(ContactCreatedDate))</P><P></P><P>But when I drill down on the chart by created month it only pulls those records with both fields populated; LeadCreatedDate &amp; ContactCreatedDate (i.e. converted leads).</P><P></P><P>Is there a way to combine 2 fields from seperate tables or should this be done in the Load script?</P><P></P><P>Thanks</P><P>Jon</P></BODY></HTML> Mon, 13 Aug 2012 12:05:49 GMT https://community.qlik.com/t5/QlikView/Using-same-field-from-different-tables/m-p/377335#M140694 2012-08-13T12:05:49Z