topic Re: Relationship between table Qlikview in QlikView https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715124#M538548 <HTML><HEAD></HEAD><BODY><P>Thank you, Suraj</P></BODY></HTML> Thu, 04 Sep 2014 22:35:12 GMT 2014-09-04T22:35:12Z Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715119#M538543 <HTML><HEAD></HEAD><BODY><P>If I have the following tables</P><P></P><P>Discounts:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date_Discount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rate</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.06&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P></P><P></P><P>Sales:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales_Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 95</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.06&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125</P><P></P><P>How could i get the following table?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales_Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rate</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.03&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.04&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.05&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.06&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2014.04.07&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P></BODY></HTML> Thu, 04 Sep 2014 21:12:58 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715119#M538543 2014-09-04T21:12:58Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715120#M538544 <HTML><HEAD></HEAD><BODY><P>is this ?</P><P></P><P><IMG alt="P00.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65964_P00.png" style="width: 620px; height: 315px;" /></P></BODY></HTML> Thu, 04 Sep 2014 22:02:05 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715120#M538544 ecolomer 2014-09-04T22:02:05Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715121#M538545 <HTML><HEAD></HEAD><BODY><P><IMG alt="Tables.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/65969_Tables.jpg" style="width: 620px; height: 150px;" /></P></BODY></HTML> Thu, 04 Sep 2014 22:17:56 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715121#M538545 2014-09-04T22:17:56Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715122#M538546 <HTML><HEAD></HEAD><BODY><P>Its pretty much the same what enrique has done. Instead I have done a left join.</P></BODY></HTML> Thu, 04 Sep 2014 22:21:45 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715122#M538546 2014-09-04T22:21:45Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715123#M538547 <HTML><HEAD></HEAD><BODY><P>My question is: How do union</P><P></P><P>Where there is no discount for the Sales_date, take off immediately above.</P></BODY></HTML> Thu, 04 Sep 2014 22:30:57 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715123#M538547 2014-09-04T22:30:57Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715124#M538548 <HTML><HEAD></HEAD><BODY><P>Thank you, Suraj</P></BODY></HTML> Thu, 04 Sep 2014 22:35:12 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715124#M538548 2014-09-04T22:35:12Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715125#M538549 <HTML><HEAD></HEAD><BODY><P>Thank you, Enrique.</P><P></P><P>I did not see the attachment</P></BODY></HTML> Thu, 04 Sep 2014 22:39:13 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715125#M538549 2014-09-04T22:39:13Z Re: Relationship between table Qlikview https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715126#M538550 <HTML><HEAD></HEAD><BODY><P>How could i do something more dynamic?</P></BODY></HTML> Fri, 05 Sep 2014 14:31:01 GMT https://community.qlik.com/t5/QlikView/Relationship-between-table-Qlikview/m-p/715126#M538550 2014-09-05T14:31:01Z