Sense CSV Export

[dmitry909]

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?

[Gysbert_Wassenaar]

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.

[reddy-s]

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]

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]

Hi Sangram!

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

[reddy-s]

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

[ashokamp]

Hi Sangram,

Can you throw some light on the extension object?

Thanks

Ashok

[undergrinder]

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.

[reddy-s]

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]

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