topic Re: Google Maps Implementation Issue in QlikView

Google Maps Implementation Issue

Thu, 14 May 2015 10:14:39 GMT

Hi All,

I am learning Qlikview and faced below issue while implementing google maps . I am using attached PDF as reference to do this scenario.

Code is as below :

Table1:

LOAD FirstName,

LastName,

City,

ProductSold,

Year

FROM

(ooxml, embedded labels, table is Sheet1);

let noRows = NoOfRows('Table1')-1;

for i=0 to $(noRows)

let a=peek('FirstName',$(i),'Table1');

let b=peek('LastName',$(i),'Table1');

let c=peek('ProductSold',$(i),'Table1');

let address=peek('City',$(i),'Table1');

Data:

LOAD

'$(a)' as FirstName,

'$(b)' as LastName,

'$(c)' as ProductSold,

'$(address)' as Address

,subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude

next i;

Siva_Sankar — Thu, 14 May 2015 10:52:29 GMT

Hi Puneet,

What is the issue you are facing? Are there any error messae?

Can you explain?

Thu, 14 May 2015 10:56:46 GMT

Issue is: 0 rows are getting fetched in the second step for each of the rows .

Siva_Sankar — Thu, 14 May 2015 11:09:37 GMT

Can you upload your qvw file?

jpenuliar — Thu, 14 May 2015 12:50:34 GMT

the code in your Load section is using the old api.

Try Recode your Load script with the attached code.

Thu, 14 May 2015 19:24:44 GMT

Thanks !! It Worked .

Appreciate your quick help.