topic Re: Join Tabular in QlikView

Join Tabular

Sun, 07 Dec 2014 05:29:42 GMT

Dear all,

Is it possible to make relationship between two tabular data..In one tabular i have sales qty and sales value.. in another tabular i have article name and article category.. Now i want to make a relationship between two tabular and finally data will be show one tabular..For your better understanding please see below attachment.

Re: Join Tabular

nagaiank — Sun, 07 Dec 2014 05:52:29 GMT

For your sample data, no special efforts needed. If you load the data in two tables, one having fieldnames Article, [Sale Qty], and [Sale Value] and the other table having the fieldnames Article, Stock and Categorry, the tables are linked automatically. You may create a Table Box with all the fieve fields to see the data in one table.

Re: Join Tabular

Sun, 07 Dec 2014 06:14:55 GMT

Dear Nagaink,

Thanks for your prompt reply.

Re: Join Tabular

its_anandrjs — Sun, 07 Dec 2014 07:07:53 GMT

Hi,

In this two tables there is a common field names Article so by this this two table connect to each other and by this you can get the records of this two table into single table.

And you can also join this table or will be leave the association way

1. First way is

Load Article, [Sale Qty], and [Sale Value] From Source;

Load Article, Stock and Category From Source;

2. Second way of doing same is

Load Article, [Sale Qty], and [Sale Value] From Source;

Join

Load Article, Stock and Category From Source;

Regrads

Anand