Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

benwspx1
New Contributor III

Associate a value across records in two related tables

Table A contains some quote and order data. Table B contains some supplemental data. They are related by the SalesDocumentItem key.

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.

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.

Capture.JPG

1 Reply
felipedl
Valued Contributor III

Re: Associate a value across records in two related tables

Hi Benjamin,

You could try something like the attached QVW.

Best regards,

Felipe.