topic Create a qvd and tabdeliminated file for tablebox in QlikView

Create a qvd and tabdeliminated file for tablebox

jagannalla — Tue, 16 Aug 2011 15:07:06 GMT

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.

Re: Create a qvd and tabdeliminated file for tablebox

matt_crowther — Tue, 16 Aug 2011 15:31:10 GMT

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

Create a qvd and tabdeliminated file for tablebox

kaushiknsolanki — Wed, 17 Aug 2011 10:45:21 GMT

Hi,

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

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

Regards,

Kaushik Solanki

Create a qvd and tabdeliminated file for tablebox

jagannalla — Wed, 17 Aug 2011 10:54:45 GMT

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.

Create a qvd and tabdeliminated file for tablebox

kaushiknsolanki — Wed, 17 Aug 2011 11:37:17 GMT

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

Create a qvd and tabdeliminated file for tablebox

jagannalla — Wed, 17 Aug 2011 12:11:25 GMT

Ok kaushik thanks for your description.