topic Re: Combine two field from two different table in QlikView

Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 00:56:20 GMT

Hi all,

I have a cyclic group that consist of two field, Arrival and Departure.

Arrival means Point A to Point B, Point B could be many places

Departure means from Point B to Point A.

User are able to select the arrival and departure location to retrieve the data.

However, I would like to create a custom new field on the cyclic group for to and fro,

therefore if user choose France, it basically means total France trip inregardless of arrival and departure.

However I do not have any fields for to and fro in my database

Is there any way I can add to the cyclic group that add Arrival + Departure?

Thank you very much

*Both arrival and departure comes from different table namely Market_Classification_Arrival and Market_Classification_Departure

Re: Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 02:52:10 GMT

any help

Re: Combine two field from two different table

sivarajs — Tue, 25 Jun 2013 04:59:03 GMT

Market_Classification_Arrival&'-'&Market_Classification_Departure as New_Field

Re: Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 05:09:22 GMT

Under market_Classification_arrival table consist of arrival field

and

Under market_Classification_departure table consist of departure field

I have not edit any code before, is it possible if you can guide me through, thanks alot

Re: Combine two field from two different table

Tue, 25 Jun 2013 05:45:27 GMT

Hi,

This would be done at frontend where you need to combine two fields using "&" under the Calculated dimension.

But this will impact your chart performance.

You could also do this activity at back end using joins depending on ur data model build up.

Regards,

Nitin Jain

Re: Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 05:50:15 GMT

whats the code that I should put on the calculated dimension? I tried to put "&" on calculated dimension but it is not working

Will be better if I can edit without editing script though

Re: Combine two field from two different table

parthiband — Tue, 25 Jun 2013 06:01:12 GMT

Aggr(Market_Classification_Arrival&'-'&Market_Classification_Departure,

Market_Classification_Arrival,

Market_Classification_Departure)

in Calculated Dimension

It ll Work

Re: Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 06:58:49 GMT

Thanks for the code.

However this code only calculate the trips made from Indonesia to Indonesia

My desire output is from indonesia to anywhere in the world

Anywhere in the world to indonesia

Re: Combine two field from two different table

n1ef5ng1 — Tue, 25 Jun 2013 07:43:37 GMT

anybody know the reason?