Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

How to join a column in one table to another

In the attached example, I'm trying to add (join ) the column 'CP_AMOUNT'  in StdCostDateRange table to the Receipts table.  The common field is ITEM_NUMBER.

I tried  LEFT JOIN (Receipts) after the 'NoConcatenate' on the StdCostDateRange table, but it doesn't accept it.

1 Reply
Master II
Master II


I guess there is no RECEIPT_DATE field in your data model. So there is nothing to interval match an therefore nothing to join.