Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
Is this for Qlikview Maps?
Yes it is. For the QlikView Ideviomaps extension.
I am so sorry, i am not pretty much into these maps, may be some one else could able to help.