topic Export table to file QVD in QlikView

Export table to file QVD

Anonymous — Tue, 15 Feb 2011 19:46:13 GMT

Hello everyone,

I have a macro that exports a table to file QVD.
Whenever I export it overwrites the previous file.
Has some way to concatenate the data?

sub export_Estoque_Ajuste_Mes

set obj = ActiveDocument.GetSheetObject("CH19")
set val=ActiveDocument.Fields("Data_Inicial").GetPossibleValues
FUNCIONARIO = val.Item(i).Text
obj.ExportEx "D:\Desenv\ASR_"Data_Inicial".qvd", 4

end sub

Export table to file QVD

isaiah82 — Tue, 15 Feb 2011 19:51:02 GMT

Hi Washington - from the APIGuide.qvw for Member ExportEx, I believe you can just set parameter 3 = True. I've never tried that with a QVD though; let me know if it works.

-Isaiah

Export table to file QVD

Anonymous — Wed, 16 Feb 2011 11:52:07 GMT

I did not understand what you meant.

Export table to file QVD

isaiah82 — Wed, 16 Feb 2011 14:19:01 GMT

No problem; it should be as easy as changing the following line to include a third parameter:

obj.ExportEx "D:\Desenv\ASR_"Data_Inicial".qvd", 4 , True

But, unfortunately I just gave this a quick test and it doesn't work with QVD's as I feared. It does work with the text file formats however. I think you'll just need to change the 4 to a different number/format and change the load statement where you're using the QVD as such.

-Isaiah