topic Re: Chart by month from two different tables in QlikView https://community.qlik.com/t5/QlikView/Chart-by-month-from-two-different-tables/m-p/877135#M1002534 <HTML><HEAD></HEAD><BODY><P>Could you attached your raw data not the Qlikview extract?</P></BODY></HTML> Fri, 29 May 2015 11:54:23 GMT robert_mika 2015-05-29T11:54:23Z Chart by month from two different tables https://community.qlik.com/t5/QlikView/Chart-by-month-from-two-different-tables/m-p/877134#M1002533 <HTML><HEAD></HEAD><BODY><P>I have two tables in the qvw. One contains the start date and end date of the customers and using a formula I can find out how many were active on say 15th of the month. </P><P></P><P>In a separate table I have claims paid and I can create a summary by using Monthname(Treatment_Date). </P><P></P><P>However, I want the two outputs in the same table as I want to take averages.</P><P></P><P>In the excel I have attached the output from the two tables and on third sheet have shown the output which I want. </P><P></P><P>Would appreciate if someone can help me out here. </P><P></P><P>Thanks. </P></BODY></HTML> Fri, 29 May 2015 11:13:00 GMT https://community.qlik.com/t5/QlikView/Chart-by-month-from-two-different-tables/m-p/877134#M1002533 Anonymous 2015-05-29T11:13:00Z Re: Chart by month from two different tables https://community.qlik.com/t5/QlikView/Chart-by-month-from-two-different-tables/m-p/877135#M1002534 <HTML><HEAD></HEAD><BODY><P>Could you attached your raw data not the Qlikview extract?</P></BODY></HTML> Fri, 29 May 2015 11:54:23 GMT https://community.qlik.com/t5/QlikView/Chart-by-month-from-two-different-tables/m-p/877135#M1002534 robert_mika 2015-05-29T11:54:23Z