topic aout qvd files in QlikView

aout qvd files

Thu, 14 Apr 2011 11:52:34 GMT

i am ravikumar from ajzaas solutions

my query is

Is it possible to generate a qvd file automatically if it was not present in the application , If possible send the details about the process clearly

aout qvd files

Miguel_Angel_Baeyens — Thu, 14 Apr 2011 11:57:38 GMT

Hi,

QVD (storage) files are not QVW (analysis) files. In the script of any QVW file you create, you can set a STORE instruction to create a file in your filesystem, provided you have proper permissions to write in the folder, and create a QVD file with one table in it. Each time a reload takes place, if there are no conditionals affecting the process, the STORE command will be executed and the new loaded table will be saved in the same place.

Customers:LOAD Field1, Field2;SQL SELECT Field1, Field2 FROM Database.owner.table; STORE Customers INTO C:\Customers.qvd;

Hope that helps.

aout qvd files

gauravkhare — Thu, 14 Apr 2011 12:03:29 GMT

Dear Ravi,

if you have mentioned in your script the procedure for the creation of qvd's only they will generate.

eg:store ravi(tablename) into c:ravikumar/ravi.qvd....

so whenever your reload takes place then the qvd will be generated.