Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

richard1
New Contributor

GeoAnalytics - travel areas

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

1 Solution

Accepted Solutions
Employee
Employee

Re: GeoAnalytics - travel areas

3 Replies
Highlighted
richard1
New Contributor

Re: GeoAnalytics - travel areas

HI,

 

any idea plesea

 

thanks

Employee
Employee

Re: GeoAnalytics - travel areas

richard1
New Contributor

Re: GeoAnalytics - travel areas

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