topic Re: Load and save QVD in QlikView

Load and save QVD

Thu, 03 May 2012 06:06:44 GMT

How to load a QVD file and append the new data to it and save it back to its original name

Load and save QVD

sivarajs — Thu, 03 May 2012 06:18:44 GMT

create a qvd

set qvdpath=c:\file.qvd;

Tmp:

load *

from $(qvdpath);

concatenate

load fields //new data

from file.xls;

store Tmp into $(qvdpath)(qvd);

Load and save QVD

Thu, 03 May 2012 06:21:01 GMT

i tried it, but it says could not find table Tmp

Load and save QVD

kaushiknsolanki — Thu, 03 May 2012 06:23:39 GMT

Hi,

We call this as incremental load.

Have a look at the below links for documentation on incremental load

http://community.qlik.com/docs/DOC-1870

Regards,

Kaushik Solanki

Load and save QVD

Thu, 03 May 2012 06:33:02 GMT

Thanks kaushik, my case happens similar to scenario 6 as said in your dcoument. there step 5 says "Save Updated Data". i need clarification on that. i get the updated data in the report once i click the reload(say value1 changes to value2), but if i click for reload for the second time the data is rolled back(values2 changes back to value1). Same wit insert, the inserted row disappears.

Re: Load and save QVD

Thu, 03 May 2012 06:41:29 GMT

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Temp:

Concatenate(New_Table)

LOAD ID

FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

Store Temp into File.Qvd;

Correct me if i am wrong..

Load and save QVD

kaushiknsolanki — Thu, 03 May 2012 06:42:00 GMT

Hi,

Will you please share with us the script which you are using.

Regards,

Kaushik Solanki

Re: Load and save QVD

Thu, 03 May 2012 06:48:50 GMT

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Concatenate(New_Table)

LOAD ID

FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

This is the one i am using. i observe that the QVD file is not saved with the changes. Hence, the evaluation happens with the data that was available during the creation of QVD.

Re: Load and save QVD

Thu, 03 May 2012 07:16:42 GMT

Hi,

What do you mean by "the evaluation happens with the data that was available during the creation of QVD"? If you want to save it. You can use this:

New_Table:

SELECT ID from DB_Table where date>$(lastexedate);

Concatenate(New_Table)

LOAD ID

FROM

File.Qvd

(qvd)

WHERE NOT EXISTS (ID);

Inner Join SQL SELECT ID FROM DB_Table;

store New_Table into File.qvd(qvd);

Regards,

Xue Bin

Re: Load and save QVD

Thu, 03 May 2012 07:53:35 GMT

Thanks Xue Bin. It Worked

Re: Load and save QVD

farolito20 — Mon, 17 Dec 2012 23:16:34 GMT

How can I save in my qvd the date when I saved the data