Discussion board where members can get started with Qlik Sense.
I'm new in QlikView, I'm doing some testing with Qlik Sense Desktop and identified it does not do a full load of XLS spreadsheet, only download a sample of the total load.
I need, in the case of charging an XLS file, which is the maximum limit of rows and columns that QlikSense accepted to charge the full table?
PS: sorry my english bad writing. I'm from Brazil.
Go to Solution.
Limit of rows in xls files were the problem.
Hi Derek - i have no knowledge of a data volume limitation with sense. are you trying to load more than 1 sheet from the spreadsheet ? how many rows are in the spreadsheet ?
ps: the preview will not show any data if there are more than 100 columns ( i believe) , but if you run the load it will still load > 100 columns
The Data volume limitation for Qlik Sense Cloud is 25MB/ per app, but the spreadsheet have 16MB, 9 columns, and don't charge all the rows.
I need to know if the Qlik Sense make a sample of charge or has a limitation on the number of lines.
There is no limitation in Qlik Sense but there are limitations in Excel which it still doesn't seem that you have run up against.
Do you load an entire sheet or do you reference a named range when load from the Excel workbook?
Hi - yes. Qlik Cloud currently has a 25MB limit on the app/QVF file. This does not exist in desktop however. Are you seeing your issue in QLik Cloud or with Qlik Desktop ?
I moved this to the Qlik Sense Cloud forum and editing the tile. We don't want any confusion or misstating limitations.
Sorry, I was not very clear. My ploblem starts in Qlik Sense Desktop, I load an entire sheet, and only download a sample of the total load (in Qlik Sense Desktop).
I need, in the case of charging an XLS file, which is the maximum limit of rows and columns that QlikSense Desktop accepted to charge the full table?
Hi Derek - OK thanks for clarifying - I will move it back.
In order to help troubleshoot this - can you please list out the exact steps you are performing?
A fim de ajudar a resolver isso - você pode por favor listar as etapas exatas que você está executando ?
This way we can try to see what you are seeing - can you also attach the spreadsheet you are using?
Dessa forma, podemos tentar ver o que você está vendo - você pode também anexar a planilha que você está usando?
Hi Derek - following up with you - on our last request.