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]

What do you mean with 1 qlikview file? Do you mean a QVD file?

[#3]

No, in 1 schema

[jvitantonio]

If you join the tables, Qlik automatically will "unify" the tables. Can you post your application?

[#5]

that is not the solution because extended_price which i used to to get the Sales extended price and Discount Extended Price is just one field..

[jvitantonio]

Again, can you please attach your application so I can work on it?

[#7]

my application contains confidential information

[CELAMBARASAN]

Hi,

     Can you post the structure(Table definition) of the tables?

Celambarasan

[nam]

Can you post the headings in both tables , you may just need a left join

[#10]

try using a left join instead of just a join. Should pull all discounts linked to sales, but will not limit the sales if it does not have a discount.

If you want a summary that shows ONLY the sales with discount, try something like

sum(if(isnull(discount) or discount=0,0, sales)-discount)