Merge Two tables

[anuradhaa]

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.

[anuradhaa]

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

[Anonymous]

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

[anuradhaa]

But my first table has BOTh ARV and DEPT country

[Anonymous]

Will this make sense?

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

PFA..