Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

GeoAnalytics tutorial get error msg

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 ?

map error.png

1 Solution

Accepted Solutions
Quy_Nguyen
Specialist
Specialist

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

View solution in original post

13 Replies
Quy_Nguyen
Specialist
Specialist

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...

paulyeo11
Master
Master
Author

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 ?

lib folder.png

Error massage :-

lib error.png

Quy_Nguyen
Specialist
Specialist

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.

Michael_Tarallo
Employee
Employee

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

Regards,
Mike Tarallo
Qlik
paulyeo11
Master
Master
Author

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>

Quy_Nguyen
Specialist
Specialist

Yes, it's your connection name.

paulyeo11
Master
Master
Author

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>

Quy_Nguyen
Specialist
Specialist

Hi Yeo,

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

paulyeo11
Master
Master
Author

Hi Quy

My error msg as below :-

lib error final.png