Export data in CSV File from Qlik sense

[panipat1990]

Dear Team,

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

For this i am sharing a qvf file

[victorgil88]

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

[kaushiknsolanki]

Hi,

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

Install it and check again.

Regards,

Kaushik Solanki

[tejasp47]

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

[jslancas]

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

[Wallibee]

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 

[Wallibee]

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

[kaushiknsolanki]

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

I will install and check and let you know.