topic link tables in QlikView

link tables

Fri, 11 Feb 2011 05:49:08 GMT

Hi,

I have two tables as A and B.

Table A has Customerid,loggeddate,ticketcount. And the Table B has Customerid,closeddate,ticketcount. So i want to make this as a single table.

As Customerid,date,loggedticketcount,closedticketcount.. How to get the same. I should use join or mapping function.Please suggest.

link tables

deepakk — Fri, 11 Feb 2011 05:53:05 GMT

Hi XXX,

Load

Customerid,

..... from Table a

join

Load

Customerid... from table b

make sure the Customerid name is same.

link tables

maneshkhottcpl — Fri, 11 Feb 2011 05:54:46 GMT

hi,

U can concatenate the tables using the flags and the flag can be used for further calculation in chart.

e.g.

AB:

load

Customerid,

loggeddate,

ticketcount ,

'A' as Flag

from Tablesname;

concatenate

load

Customerid,

closeddate as DateAB,

ticketcount as TicketAB,

'B' as Flag

form TableB;

link tables

deepakk — Fri, 11 Feb 2011 05:54:58 GMT

hi,

Ops it will be better to concatenate....

Load

from Table a

concatenate

Load

From Table b

link tables

Fri, 11 Feb 2011 06:52:15 GMT

Thanks deepak,

But Concatenate will create a table with all rows from table A and all rows from Table B. But i want the output like this

Table A

Customer id , Arrivaldate, loggedcount

c1 02/02/2011 12

c2 02/03/2011 10

c1 02/03/2011 50

Table B

Customer Id, closeddate, closedcount

c3 02/02/2011 12

c2 02/03/2011 10

c1 02/03/2011 50

Output as

Customerid, Date, loggedcount,closedcount. .

c1 02/02/2011 12

c1 02/03/2011 50 50

c2 02/03/2011 10 10

c3 02/02/2011 12

Please suggest

link tables

deepakk — Fri, 11 Feb 2011 07:11:21 GMT

hi,

When concatenating just change the field name of the Count fields as loggedcount and closedcount and you will get the result

link tables

Fri, 11 Feb 2011 07:40:15 GMT

Thanks Deepak,

I tried both Join and concatenate.

Outcome is same in terms of count and other things. But the way the concatenate displays is each thing like below

Customer Date Loggedcount closedcount

c1 02/03/2011 10

c1 02/03/2011 20

But join displays as

Customer Date Loggedcount closedcount

c1 02/03/2011 10 20.