Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlik View, I have the data of 37,674,361 rows. I am using Excel 2010, due to limitation not able to get the details data.
Is there any option?
Hi,
Right click on your Chart/Report then select export and select csv.
But to export this many rows you must have enough RAM.
Hope it help
Regards
ASHFAQ
When you export data (table boxes, straight tables, pivot tables) into Excel from QlikView ("Send to Excel" feature), an xls file will be generated.
An xls workbook contains up to 65,536 rows by 256 columns for sheet and a number of sheets per workbook Limited by available memory.
QlikView will split all data into more sheets if the number of rows is over 65536.
see http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx
You should try to export your data into a csv file ("Export..." feature)...but it's a very big amount of data.
If you need to perform this export frequently, I suggest you find a different approach.
First question would be why? If you are exporting that much data surely you would be better to utilise the store command in the backend?
maybe he can't manage the script...