Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Open a file in desktop

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.

1 Solution

Accepted Solutions
jagannalla
Valued Contributor III

Open a file in desktop

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;

5 Replies
Not applicable

Open a file in desktop

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

Not applicable

Open a file in desktop

Hi Gordon,

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

Thanks.

jagannalla
Valued Contributor III

Open a file in desktop

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;

Not applicable

Open a file in desktop

Thnks a lot

jagannalla
Valued Contributor III

Open a file in desktop

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

Tnx gordan...