Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmitry909
Contributor III
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
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.


talk is cheap, supply exceeds demand
reddy-s
Master II
Master II

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

Hi Sangram!

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

reddy-s
Master II
Master II

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

ashokamp
Contributor II
Contributor II

Hi Sangram,

Can you throw some light on the extension object?

Thanks

Ashok

undergrinder
Specialist II
Specialist II

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
Master II
Master II

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
Contributor II
Contributor II

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