topic Re: Qlikview data export to Text file in QlikView

Qlikview data export to Text file

Fri, 19 Apr 2013 15:27:24 GMT

Hi All,

There is a way to exprot the data from QVW or reports accessed via internet can be exported to excel file.

Is there a way to export them on a text file as well?

If it is possible how it can be acheived?

Thanks,

Re: Qlikview data export to Text file

kaushiknsolanki — Sat, 20 Apr 2013 17:29:09 GMT

Hi,

Yes we can export the charts and other object individually to excel as well as text.

Just right click on the chart you want to export. Find the option to export.

Regards,

Kaushik Solanki

Re: Qlikview data export to Text file

Sun, 21 Apr 2013 10:44:21 GMT

Hi Kaushik,

Thanks a lot for reply. I have already figured it out though 🙂

For me it is taking like few mintues to export data from qvw/report pbulished online to text or excel file if the number of records are more than a million. Is that normal or it show export faster?

Thanks,

Re: Qlikview data export to Text file

kaushiknsolanki — Sun, 21 Apr 2013 12:52:27 GMT

Hi,

Its a normal. Whenever you export more than few thousands record, it will be slow.

Regards,

Kaushik Solanki

Re: Qlikview data export to Text file

nilesh_gangurde — Sun, 21 Apr 2013 17:49:44 GMT

hiii,

For millions of record if the qvw is taking few minuts to export then its fine...

i also recomend to check the data once it is exported into text file.

-Nilesh

Re: Qlikview data export to Text file

Mon, 22 Apr 2013 00:26:38 GMT

Thanks Kaushik and Nilesh, just wanted to make sure 🙂

Re: Qlikview data export to Text file

Mon, 22 Apr 2013 13:32:42 GMT

Hi,

There is another realted issue which I am facing right now.

If I export the data to Excel, sometimes Excel does not show exactly the same number of records (usually less than in qvw ). Does someone know what can be the reason?

Thanks,

Re: Qlikview data export to Text file

magdagarcia — Mon, 22 Apr 2013 16:23:35 GMT

Hi tahirghailb:

Yes, there are another way:

Inside of QEMC (Qlik View Management Console) in the next path:

tab System->Setup->QlikView Web Servers-> AccessPoint->Accesspoint Settings

1.- Change the option Full browser and small Device Version TO "IE Plugin"

2.- Clik over Apply Bottom

3.- Go again and access the Qlikview Web and dowload the informacion to Excel

4.- END

this way really work it!!!!!

regards !!!

Re: Qlikview data export to Text file

Mon, 22 Apr 2013 16:31:36 GMT

Hi Magda,

Thanks for your erply. But I am not sure if I have understood correctly.

From your answer I am getting an impression that yes it is possilbe that total number of recrods are not exproted to the Excel in some cases...is that correct?

Re: Qlikview data export to Text file

nilesh_gangurde — Mon, 22 Apr 2013 18:50:08 GMT

hiii tahirghalib,

if you are exporing the data into excel file of ms office 2003 then it will only show 65000 records.

instaed of that you can right click on the chart => then you have "Export" option. and their select ".csv" as file type and save the data.

when you export data into .csv file there will not be any mismatch.

i used to fetch 7-8 lakhs of records in csv format.

Hope this will help you.

-Nilesh

Re: Qlikview data export to Text file

Mon, 22 Apr 2013 18:54:20 GMT

Thanks Nilesh 🙂

Re: Qlikview data export to Text file

nilesh_gangurde — Mon, 22 Apr 2013 19:01:09 GMT

hiii tahirghalib,

if you found the post helpful.

please mark it as helpfull

-Nilesh