Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Copying data from QVD to excel

Dear All,

Can we copy the data from QVD to excel? Is there any chance.

Thanks,

Sridhar

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Load the data into qlikview and store it in a csv file so excel can read it.

MyTable:

LOAD * FROM MyQvd.qvd (qvd);

STORE MyTable into MyCsvFile.csv (txt);


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
MVP & Luminary
MVP & Luminary

Load the data into qlikview and store it in a csv file so excel can read it.

MyTable:

LOAD * FROM MyQvd.qvd (qvd);

STORE MyTable into MyCsvFile.csv (txt);


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

Need to consider the size of data as well

Partner
Partner

there is a realy cool free tool called q-eye

it's allows you to open qvds directly and export them to excel

Q-Eye - Overview | Products | Products

Not applicable

Load the qvd fields into a straight table, then click the send to excel button.


Thanks

Khushboo

Creator II
Creator II

You have to load the qvd into a QlikView application then create a table object to copy the data into excel.

Regards,

Padmanabhan