topic Re: Associate a value across records in two related tables in App Development https://community.qlik.com/t5/App-Development/Associate-a-value-across-records-in-two-related-tables/m-p/1260264#M25655 <HTML><HEAD></HEAD><BODY><P>Hi Benjamin,</P><P></P><P>You could try something like the attached QVW.</P><P></P><P>Best regards,</P><P></P><P>Felipe.</P></BODY></HTML> Wed, 22 Mar 2017 20:15:15 GMT felipedl 2017-03-22T20:15:15Z Associate a value across records in two related tables https://community.qlik.com/t5/App-Development/Associate-a-value-across-records-in-two-related-tables/m-p/1260263#M25654 <HTML><HEAD></HEAD><BODY><P>Table A contains some quote and order data. Table B contains some supplemental data. They are related by the SalesDocumentItem key.</P><P></P><P>Table B will contain three records for every Sales Document, items 20, 21, and 22. Table A only contains item 20. Table A contains the Status field. The Status field only exists for item 20 in the source data.</P><P></P><P><STRONG>Is there a way to associate the Status field in Table A for item 20 to Table B items 21 and 22? I'm trying to avoid changing the data model too much as it feeds multiple applications.</STRONG></P><P></P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157150_Capture.JPG" style="height: 145px; width: 620px;" /></P></BODY></HTML> Wed, 22 Mar 2017 15:52:51 GMT https://community.qlik.com/t5/App-Development/Associate-a-value-across-records-in-two-related-tables/m-p/1260263#M25654 WiscoSippi 2017-03-22T15:52:51Z Re: Associate a value across records in two related tables https://community.qlik.com/t5/App-Development/Associate-a-value-across-records-in-two-related-tables/m-p/1260264#M25655 <HTML><HEAD></HEAD><BODY><P>Hi Benjamin,</P><P></P><P>You could try something like the attached QVW.</P><P></P><P>Best regards,</P><P></P><P>Felipe.</P></BODY></HTML> Wed, 22 Mar 2017 20:15:15 GMT https://community.qlik.com/t5/App-Development/Associate-a-value-across-records-in-two-related-tables/m-p/1260264#M25655 felipedl 2017-03-22T20:15:15Z