topic Re: exporting from qlikview developer in QlikView

exporting from qlikview developer

Wed, 14 Oct 2015 14:12:34 GMT

Hello-

I have a very large data set that I previously exported to excel - no problems - slightly slow but worked just fine.

Today, I'm trying to export the exact same dataset - haven't even reloaded - and Qlikivew just hangs up and never exports.

Any ideas on why it suddenly isn't working correctly?

Thanks!!

Re: exporting from qlikview developer

Qrishna — Wed, 14 Oct 2015 14:14:34 GMT

Check If any other processes are running simultaneously.

Re: exporting from qlikview developer

Clever_Anjos — Wed, 14 Oct 2015 14:17:35 GMT

Maybe other process is stealing your RAM, please check

Re: exporting from qlikview developer

Wed, 14 Oct 2015 14:20:22 GMT

Hi, Krishna -

There are processes running but none of them look unusual...

Re: exporting from qlikview developer

Wed, 14 Oct 2015 14:24:10 GMT

Anything in particular I should be looking for? I actually got a RAM expansion that was helping it run faster before today...

Re: exporting from qlikview developer

Clever_Anjos — Wed, 14 Oct 2015 16:37:36 GMT

When you add more RAM?

Did you increase your swap area?

Re: exporting from qlikview developer

SreeniJD — Wed, 14 Oct 2015 16:43:52 GMT

Hi There-

How big is the Data and what is the size of the RAM?

CSV files are always faster to read.. see whether you can convert your excel to csv

Sreeni

Re: exporting from qlikview developer

Wed, 14 Oct 2015 19:50:25 GMT

I'm only exporting about 10,000 rows at a time. And it was working beautifully just a few days ago.

Re: exporting from qlikview developer

petter — Wed, 14 Oct 2015 20:01:56 GMT

If you have the file open in Excel - Excel will always lock the file preventing other programs from overwriting it. So could that be the case for you?

Re: exporting from qlikview developer

Wed, 14 Oct 2015 21:57:13 GMT

Unfortunately not.

Re: exporting from qlikview developer

stevedark — Wed, 14 Oct 2015 23:09:32 GMT

QlikView can struggle with very large tables and sending them out to a file. There is no quick way around it, all of the data needs to be written to disk.

Using a STORE statement in the load script is more robust, but this is dependent on you not needing to make ad-hoc selections and being able to do all calculations in the load script.

This post gives some more pointers on using STORE:

http://www.quickintelligence.co.uk/write-csv-qlikview-store/

Hope that helps,

Steve

Re: exporting from qlikview developer

Thu, 15 Oct 2015 14:38:54 GMT

Steve- This is a great workaround for me. I can't find the "Mark as correct answer button" anymore for some reason....but you rock!!! Thanks!!

Re: exporting from qlikview developer

stevedark — Thu, 15 Oct 2015 15:33:02 GMT

Hi Camilla. Glad the solution works for you. That's odd about the "Mark as Correct" button - but I'll take a "you rock" instead.