topic Re: Cyclic Group in QlikView

Cyclic Group

n1ef5ng1 — Mon, 24 Jun 2013 09:02:00 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

Mon, 24 Jun 2013 09:27:15 GMT

Let's say your table is TravelData:

// Add unique ID to Arrival + Departures combinations

LEFT JOIN (TravelData)

LOAD DISTINCT Arrival, Departures, autonumber(Arrival & Departures) as AD_KEY

RESIDENT TravelData;

// New table with the combination of Arrival and Departures

AD:

LOAD DISTINCT Arrival as AD_Name, autonumber(Arrival & Departures) as AD_KEY

RESIDENT TravelData;

LOAD DISTINCT Departures as AD_Name, autonumber(Arrival & Departures) as AD_KEY

RESIDENT TravelData;

// Now just add AD_Name to your cycle group

n1ef5ng1 — Mon, 24 Jun 2013 09:32:20 GMT

Thanks for the reply,

apparently both of the fields comes from different table.

namely, market_classification_arrival

and

market_classification_departure

Mon, 24 Jun 2013 09:47:30 GMT

If you want an appropiate answer, you have to provide the context.

Anyway, I believe the answer is to create a combination of the points in the script.

n1ef5ng1 — Mon, 24 Jun 2013 09:49:46 GMT

my bad about this, till date I have not edit the script before so I have no idea how powerful it is.

Hope you dun mind.