Combine Tables

[#1]

Hi,

I would like to know how to do this in Qlikview. I have to tables, Sales and Discount.. I got the Sales Extended Price by Left joining the Discount table to Sales Table while the Discount Extended Price by Inner join. the problem is how  can I do this in 1 qlikview file??

[jvitantonio]

If your application contains conf information, then create a new one with dummy data. We are trying to guess what you mean in order to help you. So please, when posting a question, make sure to provide the information we need in  order to help you or provide as much detail as you can.

[#3]

attached is the structure of the tables

[#4]

Please help me on this sirs, I just want to show two extended_price, the one which used Sales left join Discount and Sales inner join Discount and combine them together two have a result like in the image..

Thank you so much

[#5]

Help please...

[jvitantonio]

hEY YOUR APP is too heavy. Could you please reduce the dta a little bit?

[nam]

Hi, you need to clean up your data model, you have multiple synthetic keys, your reloading the same data into the different tables, can you send a reduced copy of the QVD files along with your qlikview then i can look at the data model for you.