Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've tried several times loading an excel file in Qlik Sense, but I can't.
It appear the screen when you have to select the fields, but the loading image (right/down) continues working. I've been waiting (this time) 30 minutes and, although the loading image is moving, the screen seems to be blocked
The excel file is an xlsx. of 1.6 MB, with 6 sheets. The first sheet have 3000 rows, and 67 columns. The others are small.
Hi Jose - do you have any blank rows - at the top of the excel file?
Can you send a screen-shot - of the first tab in the .xlsx file - please blur out any sensitive information.
Mike
Jose,
When you select the other table can you see data? or only the "farmacias" table has issues?
Jose podes enviar el excel para probarlo?
las otras pestañas del excel te muestra informacion en qlik sense?
slds, Fernando
I've deleted all the sheets but the first one, but still can't load it.
Why in the left side appears a lot of tables if I only have one sheet now?
I can load the same file in QlikView without any problems
Can't send the excel, as it has sensitive data.
The programam stops working, so I can't select any other tables.
There are any rows.
Can't send the excel, as it has sensitive data.
I've modified the data, but still not working:
What version of Sense are you using?
Would you be able to get us a version of an Excel Spreadsheet with no sensitive data that replicates the issue?
You should be able to load that Excel file into QlikView, make a table, then scramble the data (Settings -Document Settings - Scrambling Tab), and then export that back out. You can test this new scrambled file in Sense and if that works, there might be something in the data that's causing the issue.
Jose,
Have you try to do a simple excel sheet and use that? Also, any chance the current excel sheet has weird/special characters? Have you try to make a copy of your current excel file and try the "elimination process", by removing content on the excel sheet until you notice that it works, and try the last thing you removed and see if that breaks it.
Gio