topic Re: Export data in CSV File from Qlik sense in App Development

Export data in CSV File from Qlik sense

panipat1990 — Thu, 23 Feb 2017 18:37:19 GMT

Dear Team,

Kindly help me how to export data in csv from qliksense.

For this i am sharing a qvf file

Re: Export data in CSV File from Qlik sense

kaushiknsolanki — Thu, 23 Feb 2017 18:54:00 GMT

Hi,

What is the problem?

You can right click on chart and say Export Data.

Regards,

Kaushik Solanki

Re: Export data in CSV File from Qlik sense

panipat1990 — Thu, 23 Feb 2017 18:59:28 GMT

By default it is taking excel but i want to csv format in qliksense

Re: Export data in CSV File from Qlik sense

kaushiknsolanki — Thu, 23 Feb 2017 19:06:19 GMT

Hi,

By default it sends to excel, there is no option to change this.

But you can try this extension.

https://github.com/stefanwalther/sense-export

Regards,

Kaushik Solanki

Re: Export data in CSV File from Qlik sense

Anonymous — Thu, 23 Feb 2017 19:12:29 GMT

...or when it is opened in Excel you can then save it to csv format.

Re: Export data in CSV File from Qlik sense

saxofonoacn — Fri, 26 May 2017 09:44:19 GMT

Excel has a limit on rows (cca 1mill)... I am not sure what the initial requirement was here but I am facing the same issue - need to export CSVs from QS with a possibility of exporting as many rows as possible.

Re: Export data in CSV File from Qlik sense

Tue, 05 Sep 2017 03:35:33 GMT

I want the csv files...but not getting

Re: Export data in CSV File from Qlik sense

kaushiknsolanki — Tue, 05 Sep 2017 08:53:00 GMT

Hi,

Did you try the extension link i gave in earlier post?

Regards,

Kaushik Solanki

Re: Export data in CSV File from Qlik sense

saxofonoacn — Tue, 05 Sep 2017 09:09:30 GMT

It didn't work for me. Some bug... sorted the problem now but putting the CSV into to load and saving the table in a file. Cheers anyway!

Re: Export data in CSV File from Qlik sense

yanivbm88 — Tue, 03 Apr 2018 13:48:43 GMT

Hi Kaushik,

I get the following error when trying to use the extension:

'The visualization was not found on server: swr-sense-export''

I also looked in the GitHub page comments but it did not help. Do you have any suggestions?

Re: Export data in CSV File from Qlik sense

victorgil88 — Thu, 24 May 2018 09:57:32 GMT

Hi!

You can try this:

Store Name as a, RegNo as b from mytable into 'lib://FolderConnection/myfile.qvd';

At the end, it is the same as Qlikview.

Regards

Re: Export data in CSV File from Qlik sense

kaushiknsolanki — Thu, 24 May 2018 16:47:12 GMT

Hi,

It says you dont have the swr-sense-export extension installed and thus visualization failed.

Install it and check again.

Regards,

Kaushik Solanki

Re: Export data in CSV File from Qlik sense

tejasp47 — Thu, 27 Sep 2018 16:57:23 GMT

Considering the final data file with required column, grouping and Order is finally stored in [Export-CSV] table, then towards end of the scripting you can use below command to export to .csv.

Although the Extension is available for that, but it has limitation of 10 Dimensions and few Measures. If you have limited data then use Extension - https://github.com/stefanwalther/sense-export

Or export it while App loading.

Cmd -

STORE [Export-CSV] INTO ['lib://ExportPath/Test.csv'] (txt);

Re: Export data in CSV File from Qlik sense

jslancas — Fri, 09 Oct 2020 20:29:06 GMT

Store commend is no good. Want to export only those columns in my straight table. QlikView could do it. Apparently Qlik Sense cannot...??

Re: Export data in CSV File from Qlik sense

Wallibee — Tue, 01 Mar 2022 10:36:41 GMT

Hi @kaushiknsolanki

this is a great extension but I have a situation while using it and don't know if anyone faces that issue too.

I get into memory limit when I use this button to export files to format comma-separated CSV - Client-side, here I am talking of say 100k rows.

Is there a workaround to such a problem such that I can still export tables out with just a button after selections are made on the front end?

Thank you in advance

Re: Export data in CSV File from Qlik sense

Wallibee — Tue, 01 Mar 2022 11:12:44 GMT

Hi @kaushiknsolanki

The extension sense-export is a great one and has been working for me. But all of a sudden I encountered a memory limit problem.

Here I am exporting say 100k rows, and the export format is set to comma-separated CSV- Client side.

Is there a workaround with this such that I can still be able to export tables behind this button?

Thank you in advance

Re: Export data in CSV File from Qlik sense

kaushiknsolanki — Wed, 16 Mar 2022 13:13:50 GMT

@Wallibee I dont have any idea if the extension has any limit.

I will install and check and let you know.