Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
dmitry909
New Contributor III

Sense CSV Export

Hi experts!

Someone knows how we can export Qlik Sense table to CSV, not to XLS?

The purpose is to overcome limitation in 1 000 000 cells. CSV allows to export 5 mln. cells from Sense.

How we can force our exporting to CSV?

Or may be overcome these limitations in another way?

10 Replies
MVP & Luminary
MVP & Luminary

Re: Sense CSV Export

Perhaps this extension can do that for you: Object to CSV‌.

But to be honest it sounds like a very bad idea to let users export N-million rows. That sounds like you're going to use Qlik Sense merely as an ETL tool to generate data sets that will be used in other applications for analysis. Why can't that analysis be done in Qlik Sense? And if you must generate such data sets for external applications why can't you do it in the script. You can easily create csv files there with the STORE command.


talk is cheap, supply exceeds demand
reddys310
Honored Contributor II

Re: Sense CSV Export

Hi Dmitry,

What gwassenaar‌ said is absolutely right and very meaning full. I would also recommend you to use the store command to save it as a .csv

Alternatively, if you need a CSV extract from the UI itself, you will have to go with an extension object to achieve this.

Thanks,

Sangram.

dmitry909
New Contributor III

Re: Sense CSV Export

Thanks, i'll check it! But, it seems we can export only one specific object in one button, and the next limitation, that export is not respond on any selections. To be honestly, now I have not found any properly working extensions to solve this problem.

You're right about bad idea to use Qlik for such exports, but anyway, we have such a need. Good or bad, no matter, but it is limitation in Sense, and it would great if we can do this in Sense, without any additional ETL tools. For example, it may be really big report. In QlikView we have no such problems.

And we can't do this in load script, because we need apply specific user selections in our export.

dmitry909
New Contributor III

Re: Sense CSV Export

Hi Sangram!

Yeah, you're right, it's seems, the only way - to make own csw export extension.

reddys310
Honored Contributor II

Re: Sense CSV Export

Yes, Let me know if you need help building an extension.

ashokamp
New Contributor II

Re: Sense CSV Export

Hi Sangram,

Can you throw some light on the extension object?

Thanks

Ashok

undergrinder
Valued Contributor II

Re: Sense CSV Export

Hi Dmitry,

If it is suitable export the desired csv in data load editor script.

Store MyTable into lib://LibConnection/MyTable.cs (txt, delimiter is ';');

G.

reddys310
Honored Contributor II

Re: Sense CSV Export

Hi Ashok,

You will find all the documentation required for building an extension here:

https://help.qlik.com/en-US/sense-developer/2.2/Subsystems/Dev-Hub/Content/Howtos/dev-hub-extensions...

Also debugging the existing extensions on Qlikbranch will help gain some knowledge.

Thanks,

Sangram

ashokamp
New Contributor II

Re: Sense CSV Export

Hi Sangram,

Thanks for the link. Can you help me in building an extension for csv from UI . I hope it will be same for Qlikview and qliksense.

Thanks

Ashok