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

Trouble loading in excel file

I am trying to currently load in an Excel file.  Whenever Qlikview asks if my data is correct or not, it is obviously not.  All it shows is column A with a bunch of Chinese lettering underneath.  There is nothing else.  I am very confused as to why this is happening.

Labels (1)
5 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Can you provide screenshot or a sample app with this issue?

Stax
Contributor
Contributor
Author

 

 

Yes, here is what I see.fullsizeoutput_789.jpeg

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

How is your Excel structure looks like?

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Try closing the "Create a New Document" window and load the Excel file from "Edit Script".

In this window, select Table Files.

clipboard_image_0.png

Brett_Bleess
Former Employee
Former Employee

Seth, did Arthur's last post work, or are you still seeing the issue?  Can you potentially check your Document Support Info link the Help menu of the Desktop Client and see if you see anything odd there?  This might be something in the Settings.ini as well, that is located in C:\Users\UserProfileName\AppData\Roaming\QlikTech\QlikView, you can check that too.  In theory you can clear everything in the Settings.ini except the [Authentication] area if you are using a client license key, and if you are leasing, you would want to keep the leased license entries in the [Settings 7] area, everything else will repopulate, but if you customized any settings, you would need to reset those too.  Hopefully Arthur's way of doing things worked, but I cannot explain why things were doing what they were doing otherwise.  Shout back if you are still seeing things, but if you did figure something out, consider posting that and mark it as the solution use the Accept as Solution button after you apply the post.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.