Is there any process to update the Qvd files?

[jagannalla]

Hi,

- I have created some qvd files. Now, I want to update that qvd files.

- B'coz the data is changing every day in my database. The update showed be occur to generated qvd files also.

Is it possible in qlikview ? If possible how can i do this..

Can any guru help me......

[#2]

yes it is possible to Update the data in the QVD file. These are the Possibilities with the QVD file during the reload

1) Append only (Logfiles).

2) Insert only (No Update or Delete).

3) Insert and Update (No Delete).

4) Insert, Update and Delete.

Please check the reference manual for examples.

[Miguel_Angel_Baeyens]

Hello,

In the same script where you select records from your database, write a STORE statement so every table gets stored into a QVD file. So your QVD files will be replaced with the new data extracted as often as you reload.

Table:LOAD Field1, Field2;SQL SELECT Field1, Field2FROM Database.Source; STORE Table INTO Table.qvd; // rest of the script here

Is that what you are looking for?

[jagannalla]

Hi Miguel,

No no...... I know how to generate the qvd files. I want to update the qvd files daily. I mean if data is changed in the database the qvd files should be updated. Is it possible miguel.

[ashfaq_haseeb]

HI Boppy

Yes this is very much possible, In order to acheave this you have to go through a concept of qlikview called "Incremental reload"

Hope that helps

Regards

ASHFAQ

[suniljain]

Insert, Update and Delete

The most difficult case to handle is when records are actually deleted from the source database between script executions. The following conditions apply:

· The data source can be any database.

· QlikView loads records inserted into the database or updated in the database after the last script execution.

· QlikView removes records deleted from the database after the last script execution.

· A field ModificationDate (or similar) is required for QlikView to recognize which records are new.

· A primary key field is required for QlikView to sort out updated records from the QVD file.

· This solution will force the reading of the QVD file to "standard mode" (rather than "super-fast mode"), which is still considerably faster than loading the entire database.

Script example:

Let ThisExecTime = Now( );

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

[#7]

I'm not sure I understand your question, but you can create a dashboard using only script as Miguel mentioned below to create the QVD's. You don't add any objects like charts, but just schedule the dashboard on the QlikView Management Console to run as often as you want to update the QVDs.. This is how we reload our QVDs each day since the database is updated.

Table:
LOAD Field1,
Field2;
SQL SELECT Field1, Field2
FROM Database.Source;

STORE Table INTO Table.qvd;

Hope this helps.

Don Saluga