topic Combine Tables in QlikView

Combine Tables

Fri, 09 Mar 2012 12:58:09 GMT

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??

Combine Tables

jvitantonio — Fri, 09 Mar 2012 13:05:08 GMT

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

Combine Tables

Fri, 09 Mar 2012 13:15:39 GMT

No, in 1 schema

Combine Tables

jvitantonio — Fri, 09 Mar 2012 13:21:12 GMT

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

Combine Tables

Fri, 09 Mar 2012 13:25:38 GMT

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..

Combine Tables

jvitantonio — Fri, 09 Mar 2012 13:49:49 GMT

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

Combine Tables

Fri, 09 Mar 2012 14:41:13 GMT

my application contains confidential information

Combine Tables

CELAMBARASAN — Fri, 09 Mar 2012 14:45:10 GMT

Hi,

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

Celambarasan

Combine Tables

nam — Fri, 09 Mar 2012 14:47:43 GMT

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

Re: Combine Tables

Fri, 09 Mar 2012 14:48:28 GMT

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)

Combine Tables

jvitantonio — Fri, 09 Mar 2012 14:56:51 GMT

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.

Re: Combine Tables

Fri, 09 Mar 2012 21:54:58 GMT

attached is the structure of the tables

Re: Combine Tables

Sat, 10 Mar 2012 15:08:09 GMT

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

Combine Tables

Sun, 11 Mar 2012 07:52:32 GMT

Help please...

Combine Tables

jvitantonio — Mon, 12 Mar 2012 11:07:31 GMT

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

Combine Tables

nam — Mon, 12 Mar 2012 16:03:39 GMT

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.