QVD File

[Anonymous]

Hi Everyone,

I am new to QlikView and trying to use QVD file for incremental data load.

I have following question:

Is it possible to update QVD file without using STORE function?

Are there any other functions/commands which can be used with QVD files?

Does QVD file understand which data is modified or deleted while updating new data in existing QVD file?

Or we have to built the incremental data load logic only in where clause of query.

Thanks a lot

Regards,

Ajit

[Anonymous]

A QVD is simply a file that holds QlikView data.

You put data in using STORE and read it using LOAD.....  And that is all you can do with it.

Have a look at this blog post re how to do Incremental Loads, http://www.quickintelligence.co.uk/qlikview-incremental-load/

[marcus_sommer]

A qvd could be only updated with the store-command - this meant you need to load the qvd, made your adjustments (checking this or that, filter per where or add new records and so on) and then storing it again. But this musn't be mandatory slow if you could keep the biggest parts of them with optimized loadings - a where exists() clause is very helpful in such cases - see also: Advanced topics for creating a qlik datamodel

- Marcus