Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Matching One Field to Other Fields that Meet a Condition

Hello, I need help coding for this.

I have a data set that looks like this:

ExpCurve_NoExpCurve_IDExpCurve_LocExpCurve_Coordinates
1ARG_Bonito_WTDGulf Coast[-92.19726563,27.18624219]
2ARG_Cush_WTICushing, OK[-96.76697,35.9850639]
3ARG_Formula_WTICushing, OK[-96.76697,35.9850639]
4ARG_Hou_WTI_WTDHouston, TX[-95.3698028,29.7604267]
5ARG_LLSSt. James, LA[-90.8308712,29.9828316]
6ARG_LLS_WTDSt. James, LA[-90.8308712,29.9828316]
7ARG_MARS_WTDGulf Coast[-92.19726563,27.18624219]
8ARG_Midland_WTI_WTD_AVGMidland, TX[-102.0779146,31.9973456]
9ARG_Poseidon_WTDGulf Coast[-92.19726563,27.18624219]
10ARG_SGC_WTDGulf Coast[-92.19726563,27.18624219]
11ARG_Thunderhorse_WTDGulf Coast[-92.19726563,27.18624219]
12ARG_WTS_WTDMidland, TX[-102.0779146,31.9973456]
13ATLAS_WCS_CUSHCushing, OK[-96.76697,35.9850639]
14ICE_RCushing, OK[-96.76697,35.9850639]
15ICE_WBSCushing, OK[-96.76697,35.9850639]
16IPE_LBCBuckeye 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!

5 Replies
vishsaggi
Esteemed Contributor III

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

Is this what you are looking for?

Capture.PNG

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

and CurveCoordinates as your Expression.

Not applicable

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

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
Esteemed Contributor III

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

Is this for Qlikview Maps?

Not applicable

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

Yes it is. For the QlikView Ideviomaps extension.

vishsaggi
Esteemed Contributor III

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

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