Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can a straight /pivot table of a qvw be saved in new qvd file by using script of that qvw? how?
thanks
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.
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.
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.
This worked for me! Thank you
Sub SendToQVD
set obj = ActiveDocument.GetSheetObject("CH561")
obj.ExportEX "E:\ETL_DIM\TestQVD1.qvd",4
end sub