topic One to many Relationships in QlikView https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608600#M736581 <P><SPAN class="tlid-translation translation"><SPAN>Hello,</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN>I'm new to Qlikview&nbsp; and appreciate any help.</SPAN><BR /><SPAN>Is it possible to display the productID only with the highest SaleID in stright table?</SPAN> <SPAN class="">Now the productID is shown several times because it has been on several sales but I need to show only the one that have highest SaleID ( latest). Please also see the image.<BR /></SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">ProductID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SaleID</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 10</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Haven't been on sale yet ( empty)<BR /></SPAN></SPAN></P><P>I need this result: &nbsp;</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P> Wed, 25 Nov 2020 16:16:04 GMT sebbe1975 2020-11-25T16:16:04Z One to many Relationships https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608600#M736581 <P><SPAN class="tlid-translation translation"><SPAN>Hello,</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN>I'm new to Qlikview&nbsp; and appreciate any help.</SPAN><BR /><SPAN>Is it possible to display the productID only with the highest SaleID in stright table?</SPAN> <SPAN class="">Now the productID is shown several times because it has been on several sales but I need to show only the one that have highest SaleID ( latest). Please also see the image.<BR /></SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">ProductID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SaleID</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 10</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</SPAN></SPAN></P><P><SPAN class="tlid-translation translation"><SPAN class="">D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Haven't been on sale yet ( empty)<BR /></SPAN></SPAN></P><P>I need this result: &nbsp;</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608600#M736581 sebbe1975 2020-11-25T16:16:04Z Re: One to many Relationships https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608608#M736582 <P>Try: Max(SaleId)</P> Thu, 01 Aug 2019 14:56:53 GMT https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608608#M736582 vmoreno2605 2019-08-01T14:56:53Z Re: One to many Relationships https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608610#M736583 <P>Once you created the table, create a straight table chart:</P><P>Dimension:</P><P>&nbsp; &nbsp; &nbsp; ProductID</P><P>Expression:</P><P>&nbsp; &nbsp; Max(SaleID)</P><P>&nbsp;</P><P>You get the result that you want. Hope this helps.</P> Thu, 01 Aug 2019 14:58:24 GMT https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608610#M736583 trdandamudi 2019-08-01T14:58:24Z Re: One to many Relationships https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608620#M736584 <P>Thank you very much...<span class="lia-unicode-emoji" title=":grinning_face:">😀</span></P> Thu, 01 Aug 2019 15:19:38 GMT https://community.qlik.com/t5/QlikView/One-to-many-Relationships/m-p/1608620#M736584 sebbe1975 2019-08-01T15:19:38Z