Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loads freezing when loading multiple spreadsheets

Hi

i have build a QlikView app from lots of spreadsheets when i was in development i wrote the script so it only picked up one spreadsheet to make the reloads quicker. I have now finished development so want to change the script to pick up all the spreadsheets beginning with NBFso i changed the script to the below

FROM

(

biff, embedded labels, header is 6 lines, table is Sheet1$)

adding NBF*.xls to the end of the From statement. However, now when i do loads it just freezes - there are no error messages. I can't work out what i am doing wrong can anyone help?





1 Reply
Not applicable
Author

Any time i have seen that it has been due to qlikview generating a mass of synthetic keys (have you maybe got a "generic" or "noconcatenate" prefixing your load?), as a quick way of enabling you to see the table structure with your new *.xls load, put this before your table lable statament:

qualify *;

It's by no means the final solution but will let you get to the next step in debugging