Matching One Field to Other Fields that Meet a Condition

[#1]

Hello, I need help coding for this.

I have a data set that looks like this:

ExpCurve_No	ExpCurve_ID	ExpCurve_Loc	ExpCurve_Coordinates
1	ARG_Bonito_WTD	Gulf Coast	[-92.19726563,27.18624219]
2	ARG_Cush_WTI	Cushing, OK	[-96.76697,35.9850639]
3	ARG_Formula_WTI	Cushing, OK	[-96.76697,35.9850639]
4	ARG_Hou_WTI_WTD	Houston, TX	[-95.3698028,29.7604267]
5	ARG_LLS	St. James, LA	[-90.8308712,29.9828316]
6	ARG_LLS_WTD	St. James, LA	[-90.8308712,29.9828316]
7	ARG_MARS_WTD	Gulf Coast	[-92.19726563,27.18624219]
8	ARG_Midland_WTI_WTD_AVG	Midland, TX	[-102.0779146,31.9973456]
9	ARG_Poseidon_WTD	Gulf Coast	[-92.19726563,27.18624219]
10	ARG_SGC_WTD	Gulf Coast	[-92.19726563,27.18624219]
11	ARG_Thunderhorse_WTD	Gulf Coast	[-92.19726563,27.18624219]
12	ARG_WTS_WTD	Midland, TX	[-102.0779146,31.9973456]
13	ATLAS_WCS_CUSH	Cushing, OK	[-96.76697,35.9850639]
14	ICE_R	Cushing, OK	[-96.76697,35.9850639]
15	ICE_WBS	Cushing, OK	[-96.76697,35.9850639]
16	IPE_LBC	Buckeye Bahamas Hub, Bahamas	[-78.7561222,26.5126159]

I want to create a calculated field that will display ExpCurve_Loc and show all of the ExpCurve_ID that match that same location. In other words, let's say for example, for St. James, LA I need a table to show both ARG_LLS and ARG_LLS_WTD.

How can I edit my script to do this? Somebody told me I would need set analysis for this but I am somewhat new to QliKView and don't know how to do this.

Thank you in advance!

[vishsaggi]

Is this what you are looking for?

If yes, just load your data and use pivot table with Loc CUrve ID and ExpCurveNo as your Dimensions

and CurveCoordinates as your Expression.

[#3]

Hi Vishwarath!

Thank you for replying. Yes, that is what I'm looking for but instead of a pivot table I need it to show in an info bubble. I already have a map with the locations and coordinates. So now what I want is that every time I "hover" over a city (e.g. Midland, TX), I want it to show the ExcpCurve_ID that belong to that particular location.

[vishsaggi]

Is this for Qlikview Maps?

[#5]

Yes it is. For the QlikView Ideviomaps extension.

[vishsaggi]

I am so sorry, i am not pretty much into these maps, may be some one else could able to help.