Drag and Drop the Qlikview data to excel

[#1]

Hello Masters,

I have a serious problem in QV, I am using QV 9 SR3, Excel 2003, I cannot drag and drop the qvw data file into excel, could you please advise me.

Thanks in advance

Joe..

[Miguel_Angel_Baeyens]

Hello Joe,

It is working when you right click on the object and select "Send to Excel"?

Regards.

[marcohadiyanto]

hi,

i don't think it can drag and drop to excel,

but in Chart you can 'send to excel'

you go to properties chart and go to Caption in special icon box select 'Send to Excel'

then in your caption's chart will show 'XL' button. that's the button will send your chart to Excel.

Maybe it will help you.

Regards,

[#4]

Hi,

The solutions offered to you in this discussion-string point to exporting QlikView from objects into Excel. If you are trying to export a full table from QlikView into Excel, I think you might have to go down the QVD route, i.e. in your script export the table to a text/csv QVd format with the line:

store [TableName] into [Filename].csv (txt);

You will then be able to read this file in any other application, including Excel. This QVD inherits the compression associated to QVDs and is even smaller than a QVD-encoded QVD file.

Hope this helps.

[gandalfgray]

CheenuJanakiram wrote:
store [TableName] into [Filename].csv (txt);
You will then be able to read this file in any other application, including Excel. This QVD inherits the compression associated to QVDs and is even smaller than a QVD-encoded QVD file. <div></div>

What CheenuJanakiram says about size for CSV-files compared to QVD-files is not true.

A csv-file created as above will not have any "compression associated to QVDs"

The csv-file will normally be larger (or much larger) than the qvd-file (except if you have a very small table)

[#6]

Hi Goran,

Thank you for the info I was not aware of that. Do you have any knowledge of what is considered a "small file size", as most of my txt QVDs are smaller than my QVD QVDs, i.e. the largest file I had at source was 13 Gig? The txt was approx 3-4% smaller.

Regards

[#7]

Hi,

Just tested in a smaller enviro and the difference is gigantic. Don't where I was looking. My mistake.

[Miguel_Angel_Baeyens]

Hello,

There may be some misunderstanding here. A QVD file is a file format different to CSV or any other file format. Besides, a QVD file stores a XML formatted file, so there likely be some more additional information (labels?) than in a plain text file (comma or tab separated).

Is CSV what you mean for "txt QVD"?

Regards.

[gandalfgray]

The Store command stores a qv-table into a qvd or a csv file.

By default it will store the table data in qvd-format.

If you specify the format like this: (txt) qv will store the table data in csv format. This data will not be compressed in any way (see for your self with any plain text editor).

A qvd file consists of three parts.

1. XML header, describing the table and the fields

2. Symbol table in byte stuffed format

3. The actual table data in bit stuffed format.

So, since the actual data in a qvd file is compressed, a qvd file will in most cases be smaller than the correponding txt file, unless the actual data content of the table is so small that the XML overhead in the qvd file will make it larger,

or if the records of the table has a high degree of uniqueness, (in fact I believe a table consisting of just an unique ID field will always be larger as qvd than as txt)

I do not have qvd:s of 13G size but if I save a 783 MB qvd table as txt it becomes 1.48 GB (apr. 100% larger)

a 176 MB qvd becomes a 249 MB txt (apr. 50% larger)