topic Re: Merge Two tables in QlikView

Merge Two tables

anuradhaa — Fri, 06 Nov 2015 05:43:38 GMT

HI,

I have below tables

COUNTRY	COUNT
A	43
B	551
D	673
Total	1267
COUNTRY	COUNT
D	708
Total	708
COUNTRY	COUNT
A	330
B	7
Total	337

I have created them from qlikview. here i use country as dimension. But three charts values are different. say cart one country is arrival country, chart 2 it's current country etc.

So that's why i use separate charts. Is there a way to merge those dimension hence countrie are A,B,D

Else can i combine these three tables in qlikview UI.

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 05:46:05 GMT

you can concatenate these tables with a Flag in each table:

and then you can use that flag as a identifier at UI in expressions

Re: Merge Two tables

anuradhaa — Fri, 06 Nov 2015 05:47:19 GMT

can you pls share an example.

Re: Merge Two tables

tresB — Fri, 06 Nov 2015 05:48:03 GMT

If you concatenate them at the script, it works the way you want. try to share a sample qvw with your sample tables and let us help you show how.

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 05:49:16 GMT

Post some sample data

Re: Merge Two tables

jagan — Fri, 06 Nov 2015 05:59:42 GMT

Hi,

Try like this

Data:

LOAD

COUNTRY,

COUNT,

'Arrival' AS Datatype

FROM DataSource1;

Concatenate(Data)

LOAD

COUNTRY,

COUNT,

'Current' AS Datatype

FROM DataSource2;

Concatenate(Data)

LOAD

COUNTRY,

COUNT,

'SomeOthertype' AS Datatype

FROM DataSource3;

Now use

Dimension: COUNTRY

Expression: Sum(COUNT)

Hope this helps you.

Regards,

Jagan.

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 06:02:48 GMT

sth like this?

PFA..

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 06:05:39 GMT

For your arrival Country, you can use expression like this:

Dimension would be common, Country as Dim

=sum({<Flag={'Arrival'}>} count)

similarly for others

Re: Merge Two tables

anuradhaa — Fri, 06 Nov 2015 06:27:49 GMT

Hi ,

Please find attached excel sheet.

There in the above table it has ARRV Country and DEPT country.

In the NEXT table it has Current Country.

Hint : Current country is available only for ID that don't have DEPT Country

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 06:30:18 GMT

Already shared with you..

Check it..

Re: Merge Two tables

anuradhaa — Fri, 06 Nov 2015 06:43:08 GMT

Got it and thanks. But please check my excel. It's bit different from that thing

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 06:50:05 GMT

It not different, you can create it in same way.

In my QVW there are 3 table.

In your Excel, their are 2 table, you can do it in similar way

Re: Merge Two tables

anuradhaa — Fri, 06 Nov 2015 06:52:23 GMT

But my first table has BOTh ARV and DEPT country

Re: Merge Two tables

Anonymous — Fri, 06 Nov 2015 06:55:08 GMT

Will this make sense?

Both are linked with ID, you need to change dimension only.

PFA..