I am facing some problem in exporting objects to excel, when data size exceeds 10MB. Either it got exported in a new window as csv or it got failed. How can i achieve this, whether it is possible to achieve this?
Export it either to csv, use a macro to do the export to excel.
Or change the easter egg setting RowLimitForCsvInsteadOfXls. In the Help menu select About Qlikview. Then right click on the Qlikview icon in the lower left corner. Find the entry RowLimitForCsvInsteadOfXls. You can then increase the value from 65500 to a higher number.
