topic creating QVD in QlikView

creating QVD

Anonymous — Sun, 18 Jul 2010 22:16:44 GMT

I am creating QVD for the first time, where do i write store command ?

beginning of the load statement or after the select statement ?currently i have it as below and when i save and reload the scripts it is fetching the records.

Actually the reson for me creating QVD is , my table has got more than 10 million records, whenever i reload the scripts after fetching some 2 million rows i get an error message saying out of virtual memery , so someone said that these kind of issues can be handled by a QVD,

But here this even started fetching the rows ? i know eventually even this says out of memory ....

How do i handle this?

DW_T_JOBDATA:

LOAD
DATE(FLOOR(FINISH_TIME)) AS FINISH_DATE,
YEAR(FINISH_TIME) AS YEAR,
MONTH(FINISH_TIME) AS MONTH,
DAY(FINISH_TIME) AS [DAY];

SQL SELECT * FROM PIOWNER."DW_T_JOBDATA" where FINISH_TIME > SYSDATE - 30 ;

STORE DW_T_JOBDATA into \\qlikview\PDS Data\my forlder\DW_T_JOBDATA.QVD;

creating QVD

sparur — Mon, 19 Jul 2010 06:19:11 GMT

Hello.

Your script is right.

STORE statement must use after LOAD/SQL SELECT.

But if you get an error about out of virtual memory, that I think that you have a little physical memory. So you should add memory or share LOAD statement on some different parts. For example, you should load data by YEAR and store it in different QVD files.

creating QVD

suniljain — Mon, 19 Jul 2010 07:58:49 GMT

Storage_Location:

LOAD SID_SID as SID_0STOR_LOC,

Plant_PLANT as Plant_Storage_Location ,

[Storage lo_STOR_LOC] as Storage_Location

FROM

(qvd);

Store Storage_Location into

creating QVD

Anonymous — Mon, 19 Jul 2010 21:03:53 GMT

So how do i get multiple QVD's into one Qlikview file. I have multiple Clusters data , i think i will get each cluster data with one QVD, can i have a filter on all cluster in the QVW i get data into??

creating QVD

suniljain — Thu, 23 Sep 2010 08:45:28 GMT

Yes, You can Filter according to your requirement.