This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am loading an xlsx file into Qlikview that only contains 3000 lines of Data.
However Qlikview seems to to load all rows including Blank Data, so when I reload the qvw I get over 1 million rows
I have deleted formatting and all cells below the 3000 i need but it still loads over 1 million
I've had to do this before:
1 - Open a new instance of excel
2 - Copy and paste the data part from your 'data' spreadsheet into your new spreadsheet
3 - Save your new spreadsheet
4 - Try loading your new spreadsheet
Maybe it will work for this situation too. Good luck!
I realize I can do this but if I get an updated file I don't want to have to copy and paste each time.
I found an issue on line 1048418 just before the end of the excel file that seems to be a Table in Excel so I removed it and it worked
Thanks for your help though