topic Re: data Exporting Issue in QlikView

data Exporting Issue

svsudhakar — Thu, 12 Dec 2013 11:26:07 GMT

Hi ,

I have created one straight table report. It's having 30 fields. While exporting that report in to Excel I am getting Out of Memory Exception.

That report having nearly 3lacs records. Please suggest.

Below are the error screen shot. Please find it

Thanks in Advance..

Thu, 12 Dec 2013 11:41:36 GMT

RAM issue.. Try applying some filter and your export should work..

svsudhakar — Thu, 12 Dec 2013 11:47:00 GMT

Thanks Danial for your reply.

Actual scenario is user wants it in single Excel file and more over don't want any filters also.

Please suggest is there any other solution for this.

Thu, 12 Dec 2013 12:24:50 GMT

If you're working on a VM you could try allocating more RAM.

Also see if you can delete fields, perform computations in the backend, replace if statements with set analysis.

Just for testing purposes I suggest trying to make a smaller export first, see if that works (ie. only 2013 if you've data for several years).

Thu, 12 Dec 2013 12:26:46 GMT

Hi ,

You can export that staright table like select that table--propersties--export-save as in (qvd) then open that qvd.

then store that data into your required format whether excel or csv or txt.Its better to store in txt format for large no. of records.

To store use below:

store t1 into path\file.txt(txt, delimiter is '|' );

Rgds,

Harshal Patil

Clever_Anjos — Thu, 12 Dec 2013 12:29:34 GMT

If is possible, preagregate all your expressions and use a Table Box instead of Straight Table.

Table box is much less RAM intensive