https://community.qlik.com/t5/QlikView/Extending-Dimension-to-Second-table/m-p/1768572#M718713 <P>Hi WilsonEvans,</P><P>Do your tables have data for all days in the period ? Maybe one could have Sales for day 12 and the other no... This would be a problem for Qlikview...&nbsp;</P><P>BR,</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Dec 2020 11:27:51 GMT Marcos_Ferreira_dos_Santos 2020-12-15T11:27:51Z https://community.qlik.com/t5/QlikView/Extending-Dimension-to-Second-table/m-p/1768074#M718712 <P>I have two tables T1 and T2. I have joined them with Year month of Date D1 in T1 with Year month of Date D2 in T2. Now i need to build a chart to see the daily trends. My Dimension is Day(D1) and my expression is sum(Sales1 in T1)/sum(Sales2 in T2). But when i do this, the numerator is grouped by the Day(D1) whereas the denominator is not grouped by Day(D2). I want it to be Day(D1) = Day(D2) for calculating the daily metrics. Any idea on how to achieve this?&nbsp;</P><P>Thanks!</P> Sat, 12 Dec 2020 08:10:57 GMT https://community.qlik.com/t5/QlikView/Extending-Dimension-to-Second-table/m-p/1768074#M718712 WilsonEvans 2020-12-12T08:10:57Z https://community.qlik.com/t5/QlikView/Extending-Dimension-to-Second-table/m-p/1768572#M718713 <P>Hi WilsonEvans,</P><P>Do your tables have data for all days in the period ? Maybe one could have Sales for day 12 and the other no... This would be a problem for Qlikview...&nbsp;</P><P>BR,</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Tue, 15 Dec 2020 11:27:51 GMT https://community.qlik.com/t5/QlikView/Extending-Dimension-to-Second-table/m-p/1768572#M718713 Marcos_Ferreira_dos_Santos 2020-12-15T11:27:51Z