topic Re: Exporting to EXCEL in QlikView

Exporting to EXCEL

Anonymous — Thu, 11 Sep 2014 15:32:45 GMT

Dear folks,

if i export 5 crores records from my qlikview document to excel..what ll happen?? is it possible to export crores records to excel...

Sorry if i asked a stupid question(i faced this question in interview)

Thanks in Advance.

ecolomer — Thu, 11 Sep 2014 15:53:20 GMT

Yes you can expot to excel

Anonymous — Thu, 11 Sep 2014 15:57:20 GMT

Thanks for the reply......actually i just want to know the limit of records we can transport to excel.....

ThornOfCrowns — Thu, 11 Sep 2014 16:00:59 GMT

65,000 or 1,048,576 depending on your version of Excel.

Anonymous — Thu, 11 Sep 2014 17:19:55 GMT

thank u.... mine is ms office 2013 and what ll happen exactly if i try to export more than its limit???

ashfaq_haseeb — Thu, 11 Sep 2014 18:04:18 GMT

Then it will support 1,048,576

If you export as csv it will hold many values.

Provided you need to have enough ram.

Regards

ASHFAQ

Anonymous — Thu, 11 Sep 2014 18:34:58 GMT

thanks Ashfaq..... what error will come if i try with 2 million records to export?

ashfaq_haseeb — Thu, 11 Sep 2014 18:41:33 GMT

No Errors,

If you have don't have enough ram to handle this them your commuter may consume more ram and become unresponsive.

Regards

ASHFAQ