topic Re: Matching One Field to Other Fields that Meet a Condition in QlikView

Matching One Field to Other Fields that Meet a Condition

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Matching One Field to Other Fields that Meet a Condition

vishsaggi — Mon, 17 Jul 2017 20:45:42 GMT

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.

Re: Matching One Field to Other Fields that Meet a Condition

Mon, 17 Jul 2017 20:50:46 GMT

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.

Re: Matching One Field to Other Fields that Meet a Condition

vishsaggi — Tue, 18 Jul 2017 02:36:30 GMT

Is this for Qlikview Maps?

Re: Matching One Field to Other Fields that Meet a Condition

Tue, 18 Jul 2017 02:39:38 GMT

Yes it is. For the QlikView Ideviomaps extension.

Re: Matching One Field to Other Fields that Meet a Condition

vishsaggi — Tue, 18 Jul 2017 13:06:40 GMT

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