Discussion Board for collaboration related to QlikView App Development.
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.
Yes, you can :).
10 points...now can you show me some code... ....please
product_sales:load product, group, listpriceresident prod;left joinload product, quantityresident 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.