Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting Feilds from 2 Resident Tables

Hi all,

Is there a way that you can select certain feilds from 2 tables already loaded as a sub table, essentially using a join in a resident statement.

4 Replies
adrian_costar
Contributor III
Contributor III

Yes, you can :).

Not applicable
Author

10 points...now can you show me some code... Big Smile....please

adrian_costar
Contributor III
Contributor III


product_sales:
load
product,
group,
listprice
resident prod;
left join
load
product,
quantity
resident sales


If you want in the same time to do listprice* cantity you have to load the table product_sale again ad do the calculations.

Not applicable
Author

thanks...