Discussion Board for collaboration related to QlikView Deployment.
I am facing one issue into send to excel data.
where if my No of rows are more that 65 K approx then it will stores the data into sheet1 and remaining data are getting store into sheet2.
but i want to make it into sheet 1 only however the data will be.
Do i need to do some modification or changes on some server settings or into Application.
thanks in advanced.
In Microsoft office 2003,
Limited by available memory and system resources
65,536 rows by 256 columns
But Microsoft office 2010,
1,048,576 rows by 16,384 columns
which version you are using?
I am using Microsoft office 2010 & QlikView 11.2. SR 2.
Do i have to do some changes to get into One sheet.
Due to the row limit in excel, it can't handle more than 65,000 records in one sheet. You can try exporting in CSV by using export option. There is no row limit in CSV file.
Thank you sankalp,
do i have to do any changes ???
if so what are the changes i have to make??
No changes are required, just right click and use export option.
This properties does not exist into AJAX Mode.
You need to right click on the chart/table box and use export option.
Please refer the screenshot, property do exist.
Thanks for your response, but in my Case I am not getting all this options.
PFA of Screenshot.
I think i have do some changes to get this option.
I am trying CSV file, there is no limit into CSV file.