Create a qvd and tabdeliminated file for tablebox

[jagannalla]

Hi,

I've a tablebox. And i'm trying to create a qvd file and tabdeliminated file through macro. But, when i see the result of this files size it is same for both. I don'k know where i'm missing.

i tried in macro as below

For tabdeliminated file..

obj.Export "C:\test\test.txt","     "

For qvd file...

obj.Export "C:\test\test.qvd",","

- Not only this  Export method, i tried with different number of methods which are given in API guide(i.e ServerSideExport, ServerSideExportEx....)but no method is generating qvd file with less size.

- One more thing is after generating qvd file with Export method. I tested whether the qvd file is correctly generated or not. I mean when i loading this qvd file in editscript it is showing with deliminater format instead of qvd file. But when i see the datatype in folder it looks QVD.

[matt_crowther]

http://community.qlik.com/message/5448#5448

You don't need the ',' for the QVD export but the addition of a control '4' is required - see post.

Hope that helps,

Matt - Visual Analytics Ltd

[kaushiknsolanki · Accepted solution]

Hi,

   Have a look at the explanation i have given in this post.

  http://community.qlik.com/message/141483#141483

Regards,

Kaushik Solanki

[jagannalla]

Ok kaushik thanks for your breify explaination. But what about the size of qvd and tabdeliminated file.

"But, when i see the result of this files size it is same for both."

as i mentioned in the post.

[kaushiknsolanki]

Hi,

    As i said that whenever you use Export command, data will be sent in delimited format.( You have used Export command to create a QVD)

   Use ExportEx or ServerSideEx.

   If you have created QVD using ExportEx, then there may be a posibility that your data contains more unqiue values, and thus you are getting the same sizes of both the files.

   Qvd compression happends only when you have less unique data. Meaning more unique the data is less will be the compression.

Regards,

Kaushik Solanki

[jagannalla]

Ok kaushik thanks for your description.