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.

[Anonymous]

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

[anuradhaa]

can you pls share an example.

[tresesco]

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.

[Anonymous]

Post some sample data

[jagan]

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.

[Anonymous]

sth like this?

PFA..

[Anonymous]

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

Dimension would be common, Country as Dim

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

similarly for others

[anuradhaa]

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

[Anonymous]

Already shared with you..

Check it..