topic Re: Copying data from QVD to excel in QlikView

Copying data from QVD to excel

sridhar_sigired — Wed, 09 Sep 2015 13:04:48 GMT

Dear All,

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

Thanks,

Sridhar

Gysbert_Wassenaar — Wed, 09 Sep 2015 13:16:05 GMT

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);

Wed, 09 Sep 2015 13:17:43 GMT

Need to consider the size of data as well

lironbaram — Wed, 09 Sep 2015 13:18:18 GMT

there is a realy cool free tool called q-eye

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

Wed, 09 Sep 2015 13:25:07 GMT

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

Thanks

Khushboo

padmanabhan_ram — Wed, 09 Sep 2015 13:43:53 GMT

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

Regards,

Padmanabhan