save table of qvw into qvd

[#1]

Can a straight /pivot table of a qvw  be saved in new qvd file by using script of that qvw? how?

thanks

[Gysbert_Wassenaar · Accepted solution]

You can't save a straight table or a pivot table into a qvd. Only the data of a data table can be saved in a qvd. In the script you can do this with the STORE command.

STORE mytablename into MyQvdFile.qvd;

See the help file for details. Replace mytablename with the name of the table you want to save in a qvd.

[#3]

I don't know if you can do that in the script. But you can save a straight table into a qvd.

Option 1:

     Right-click table --> Export --> in 'Save as type', choose QVD file

Option 2:

     Use the macro:

     sub SendToQVD()

           set obj = ActiveDocument.GetSheetObject("ChartID")

          obj.ExportEx "NameofFile.qvd", 4

     end sub

(NameofFile is your chosen name for the QVD you are about to save the straight table to)

     For example:

     sub SendToQVD()

           set obj = ActiveDocument.GetSheetObject("CH03")

           obj.ExportEx "StraightTableForSales1.qvd", 4

     end sub

You can then put the macro in a button the user cn click, or automate it with a trigger

See:

How to save expression data created in straight table as a QVD File., How to Export straight table - Qlikview Server

for more information.

Kind Regards.

[rygreene3]

This worked for me!  Thank you

Sub SendToQVD

set obj = ActiveDocument.GetSheetObject("CH561")
obj.ExportEX "E:\ETL_DIM\TestQVD1.qvd",4

end sub