topic Open a file in desktop in QlikView

Open a file in desktop

Mon, 23 Jan 2012 10:18:04 GMT

Hi,

I want to open a 600 MB file on my local machine.(Desktop) but unable to due to less RAM. Other than increasing the RAM, is there any other solution to it?

Thanks.

Open a file in desktop

Mon, 23 Jan 2012 10:28:39 GMT

Do you need all the data or are do you need to open it just for the purposes of reviewing the document (script/UI or whatever)?

If you dont need all the data you could use the 'first' prefix before load statements to reduce the number of records loaded to reduce the document size.

Or how about using 'reduce data'?

Regards,

Gordon

Open a file in desktop

Mon, 23 Jan 2012 13:51:59 GMT

Hi Gordon,

Is 'first' a keyword? To what extent does it reduce the data size?

Thanks.

Open a file in desktop

jagannalla — Mon, 23 Jan 2012 13:59:41 GMT

you can give your own count number to retrive the rows..

For eg:

I want to retrive only 10 records from dataset then..

First 10

Load * from

Sample.qvd;

Open a file in desktop

Tue, 24 Jan 2012 06:18:28 GMT

Thnks a lot

Open a file in desktop

jagannalla — Tue, 24 Jan 2012 09:16:02 GMT

Actually it is not my idea.. The idea came from gordan, i just implemented.

Tnx gordan...