Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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...