Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to load different KMLs in my app. I know that the Map Object have a limitation between 1000 and 3000 polygons. Am I right? Just to try I wanna show 1100 zip codes.
First, I load an island table with 2 fields: ZipCode and Area. Then I add a map with my Area and ZipCode fields with no measures and I can see the entire map.
Now I want to join the table to my data model using ZipCode as Keyfield but now, the same map, only shows a part of it.
Any idea why is doing this?
Thank's in advance
UPDATE: I attach three images for a better understanding.
Map1.png: Is my target. I only see this map if I load the table as an island.
Map2.png: Is the result of join the island table to my model using ZipCode as a Keyfield.
Map3.png Is the map using Left Keep to my facts table. As you can see there are a few blank regions, these are the regions that aren't in my model. I used Left Keep to be sure that al ZipCodes have a match in my model.
Hi Ralf and Gysbert,
I've figure out a solution.
First of all I doubled the field ZipCode. Then, I create my map adding my Area and, as dimension, I used the field that is not the keyfield.
It seems that the object is not working if we use a Keyfield which is appears several times in the fact table.
Here's the example:
Script
GIS_ZipCodes:
Load Num(City.Name,'00000') as ZipCode,
Num(City.Name,'00000') as ZipCodeDesc
City.Area as Area
FROM [lib://KML/CPS/City.kml]
(kml, Table is [City/City])
Facts:
Load Num(ZipCode,'00000') as ZipCode,
(Field1 to N)
From MySource.qvd (qvd);
Map Object
Add Area field and ZipCodeDesc as a Dimension.
Thank's for all the help.
Perhaps some areas in the kml file don't have zip code values in their attributes.
Hi Gysbert
All areas have zip code and when I select a ZipCode that don't appear in the map the field Area have some possible values and the dashboard still working.based on my selection.
Do you have data for all zip codes in the joined table?
- Ralf
Hi Ralf,
Yes, if I select one zip code that doesn't appear in the map I see data in my dashboard and the possible area as well.
Can you upload an example to illustrate. I guess there is a missing match with the KML.
Hi Ralf,
Sorry but for privacy reasons I can't upload an example. I attach three screenshots with the different results.
To be sure that there isn't a miss match with the KML I used Left Keep to my facts table to be sure that I only load the ZipCodes that appear in my model. Now I see the same part of the map, not the entire map, but with blank polygons corresponding to ZipCodes that doesn't exist in my model.
Map1.png: Is my target. I only see this map if I load the table as an island.
Map2.png: Is the result of join the island table to my model using ZipCode as a Keyfield.
Map3.png Is the map using Left Keep to my facts table. As you can see there are a few blank regions, these are the regions that aren't in my model.
Thank's a lot for your help!
Hi Ralf and Gysbert,
I've figure out a solution.
First of all I doubled the field ZipCode. Then, I create my map adding my Area and, as dimension, I used the field that is not the keyfield.
It seems that the object is not working if we use a Keyfield which is appears several times in the fact table.
Here's the example:
Script
GIS_ZipCodes:
Load Num(City.Name,'00000') as ZipCode,
Num(City.Name,'00000') as ZipCodeDesc
City.Area as Area
FROM [lib://KML/CPS/City.kml]
(kml, Table is [City/City])
Facts:
Load Num(ZipCode,'00000') as ZipCode,
(Field1 to N)
From MySource.qvd (qvd);
Map Object
Add Area field and ZipCodeDesc as a Dimension.
Thank's for all the help.