topic Join 2 tables. Need help. in QlikView

Join 2 tables. Need help.

Tue, 14 Sep 2010 06:50:25 GMT

Greetings to all!

The help to the beginner is necessary.

There are 2 tables of the facts: Move and Plan.

Move:
idDate, idFirma, idGoods,idCustomer, idManager, SumSales
Plan: idDate, idFirma, idGoodsDirect, SumPlan

idGoodsDirect - top level idGoods.

How it is better to me to connect them? It is necessary to analyze the plan the fact on firm, time, idGoodsDirect, idGoods, idCustomer, idManager.

I will be grateful for any help

Thanks

Join 2 tables. Need help.

Tue, 14 Sep 2010 07:05:54 GMT

Hi Nikolai,

Plz share Excel workbook having some sample data.

I will send you QV created by it so that you can understand it better.

Join 2 tables. Need help.

Tue, 14 Sep 2010 07:06:27 GMT

A 'LEFT JOIN LOAD DISTINCT' statement should do this. It what I used when facing a similar problem to what you have described here.

Join 2 tables. Need help.

Tue, 14 Sep 2010 09:08:58 GMT

Hi Nikolai,

You will get comparisions Sales Vs Plan only for idDate, idFirma, idGoods as Customer and Manager are not available in Plan Table.

You can use the code in this structure:

idGoodsDirect

LOAD idGoodsDirect AS idGoods FROM idGoodsDirect;

Move:

LOAD idDate, idFirma, idGoods, idCustomer, idManager, SumSales FROM Move;

CONCATENATE

LOAD idDate, idFirma, idGoodsDirect AS idGoods SumPlan FROM Plan;

This will create one dimension table and other fact table with Sales and Plan consolidated data.

Hope, it would help you.

Regards,

Raj Kishor

Join 2 tables. Need help.

Tue, 14 Sep 2010 09:25:09 GMT

you make composite key

then link with first table.

Regards

Ashish

Join 2 tables. Need help.

Tue, 14 Sep 2010 10:17:04 GMT

Hi, In attachment a file with the data

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7215.TB01_5F00_20100914_5F00_111439.xls:550:0]

Join 2 tables. Need help.

Wed, 15 Sep 2010 06:58:20 GMT

Hi,

Plz refer to the attachment.

To connect two tables in this case, you don't need any special functions.

Plz go through the script (Ctrl+E).

Also, you can see Table Viewer (Ctrl+T) to understand how these two tables are connected.

Let me know if you don't understand.

Happy Thoughts