GeoAnalytics - travel areas

[richard1]

Hi,

I can't load my dataset , i have more 1000 points

is geoanalytics is  limited and are exist a solution in this case

thanks

[richard1]

HI,

any idea plesea

thanks

[Jonas_Karlsson · Accepted solution]

Hi,
please take a look at the metrics in this document: https://www.qlik.com/us/-/media/files/legal/license%20agreements/additional%20terms/qlik-geoanalytic...

You can always split the request according to this guide: 

https://community.qlik.com/t5/Qlik-GeoAnalytics-Documents/Splitting-up-GeoAnalytics-connector-operat...

BR

/Jonas

[richard1]

Hi Jonas,

Thanks you for your answers,  i am following the guide above and i can't  do it

this my script

/* Generated by GeoAnalytics for operation TravelAreas ---------------------- */
[_inlineMap_]:
mapping LOAD * inline [
_char_, _utf_
"'", '\u0027'
'"', '\u0022'
"[", '\u005b'
"/", '\u002f'
"*", '\u002a'
";", '\u003b'
"}", '\u007d'
"{", '\u007b'
"`", '\u0060'
"´", '\u00b4'
" ", '\u0009'
];

IF FieldNumber('FieldA', 'MyTableDataSet') = 0 THEN
 call InvalidInlineData('The field FieldA in MyTableDataSet is not available');
END IF
IF FieldNumber('Adresse Point', 'MyTableDataSet') = 0 THEN
 call InvalidInlineData('The field Adresse Point in MyTableDataSet is not available');
END IF
Let [Isochrones10InlineTable] = 'FieldA' & Chr(9) & 'Adresse Point';
Let numRows = NoOfRows('MyTableDataSet');
Let chunkSize = 1000;
Let chunks = numRows/chunkSize;
For n = 0 to chunks
 Let chunkText = '';
 Let chunk = n*chunkSize;
 For i = 0 To chunkSize-1
  Let row = '';
  Let rowNr = chunk+i;
  Exit for when rowNr >= numRows;
  For Each f In 'FieldA', 'Adresse Point'
   row = row & Chr(9) & MapSubString('_inlineMap_', Peek('$(f)', $(rowNr), 'MyTableDataSet'));
  Next
  chunkText = chunkText & Chr(10) & Mid('$(row)', 2);
 Next
 [Isochrones10InlineTable] = [Isochrones10InlineTable] & chunkText;

[TravelAreas]:
SQL SELECT [FieldA], [Isochrones10_TravelArea], [Isochrones10_Origin], [Isochrones10_Cost], [Isochrones10_CostUnit], [Isochrones10_Status] FROM TravelAreas(costValue='10', costField='', costUnit='Minutes', transportation='car', dataset='Isochrones10')
DATASOURCE Isochrones10 INLINE tableName='MyTableDataSet', tableFields='FieldA,Adresse Point', geometryType='POINT', loadDistinct='NO', suffix='', crs='Auto' {$(Isochrones10InlineTable)}
;

Next
chunkText=''

tag field [FieldA] with '$primarykey';
tag field [Isochrones10_TravelArea] with '$geopolygon';
tag field [FieldA] with '$geoname';
tag field [Isochrones10_TravelArea] with '$relates_FieldA';
tag field [FieldA] with '$relates_Isochrones10_TravelArea';

[Isochrones10InlineTable] = '';

/* End GeoAnalytics operation TravelAreas ----------------------------------- */

DROP TABLE MyTableDataSet;

Thank you for your help

Best Regards,

Richard

[kelvin_ng]

Hi Richard,

Were you able to figure it out in the end?