Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
triciagdaly
Contributor III
Contributor III
‎2014-05-21 02:41 PM

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.

Preview file
15 KB
222 Views
0 Likes
1 Reply
whiteline
Master II
Master II
‎2014-05-21 02:48 PM

Hi.

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

106 Views
0 Likes