Exporting data

[Nikhil2725]

Hi Team,

Is there any way to export data in your Qlik Sense application without displaying them in a table first?

Thanks.. 

[shiveshsingh]

If you are doing calculation in the script, you can save it in excel format too from there only.

[Nikhil2725]

Hi Shiveshsingh ,
I have so many fields in the table, in that some i'm doing calculation in the script and some other i'm taking from the DB directly.
So I want to export it into excel file without displaying in the UI

[shiveshsingh]

Then you can create a resident table with all the required fields and then use store command to save that table into excel.

[Nikhil2725]

I have more than 400 columns to display in the final UI.. I think I cant add that many in the Resident table and do

[Nikhil2725]

Any other ways to do by any extensions like that?

[jonathandienst]

You can export a table as a qvd or text file during the load script (Store command)

[Nikhil2725]

Hi Jontydkpi ,

Can I export to any excel file or CSV file from that?

[shiveshsingh]

Yes, you can save it into excel from store command

[Nikhil2725]

Can u please share me the code snippet to do like tat?