topic Re: GeoAnalytics tutorial get error msg in App Development

GeoAnalytics tutorial get error msg

paulyeo11 — Wed, 22 Aug 2018 08:47:31 GMT

Hi All

Qlik Geocoding - Street Addresses and Qlik GeoAnalytics

When i run the above link QVF , i get below error. below of below path issue :-

FROM [Lib://AttachedFiles/video_game_stores.xlsx]

May i know how to set the above path or where i should place the excel file at which directory folder ?

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Wed, 22 Aug 2018 09:19:37 GMT

Hi,

You need to create a new folder connection, put your xlsx file in the folder, edit that path script with your connection name then reload the application.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/LoadData/connect-data-sources-data-load-editor.htm

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Wed, 22 Aug 2018 15:01:18 GMT

Hi Quy

I save the excel file below directory.

C:\Users\Paul Yeo\Dropbox\5 QV_Final\QV_INPUT

I also create a lib folder name , as below , But i still get error msg . may i know where i go wrong ?

Error massage :-

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Wed, 22 Aug 2018 15:53:08 GMT

It should be :

FROM [lib://lib/video_game_stores.xlsx]

lib:// is just the keyword to read from library, follow it will be the library name and further path.

Re: GeoAnalytics tutorial get error msg

Michael_Tarallo — Wed, 22 Aug 2018 16:59:01 GMT

Hi Yeo - are you ok with this? Quy has provided correct information, so please let us know if we can further help you.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Michael Tarallo

Qlik

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Wed, 22 Aug 2018 23:35:58 GMT

Hi Quy

You suggest lib://lib/

May I know the 2nd lib is because my folder name lib ?

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Thu, 23 Aug 2018 01:18:42 GMT

Yes, it's your connection name.

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Thu, 23 Aug 2018 01:32:58 GMT

Hi Quy

Look like every thing is okay . But I still get error . Not sure where go wrong ?

Paul Yeo

Director

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Thu, 23 Aug 2018 01:51:03 GMT

Hi Yeo,

Please post the error here so i and other friends can help you easily.

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Thu, 23 Aug 2018 01:56:07 GMT

Hi Quy

My error msg as below :-

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Thu, 23 Aug 2018 02:02:54 GMT

Your should replace [lib://video_game_stores.xlsx] by [lib://lib/video_game_stores.xlsx]

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Thu, 23 Aug 2018 02:08:59 GMT

Hi Quy

You are correct , now working fine.

May I know why I need to add lib ?

Paul Yeo Poh Sai

Director

TDS Technology (S) P/L

HP +6593261804 Whatsapp

HP +6280883521036 INDO

Re: GeoAnalytics tutorial get error msg

Quy_Nguyen — Thu, 23 Aug 2018 02:26:31 GMT

Hi Yeo,

Because you created a connection named lib with the path to your excel file.

If your connection name is MyData , the string will be [lib://MyData/video_game_stores.xlsx]

Re: GeoAnalytics tutorial get error msg

paulyeo11 — Thu, 23 Aug 2018 02:35:52 GMT

Hi Quy

Now i understand where i go wrong.

Meaning there are 2 lib , first lib is a must . it is a default for write this script.

Paul Yeo