Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Anonymous
Not applicable

Export to Excel by script with Qlik Sense

Hello everyone,

I want to export my datas to excel by a script. I didn't find anything that helped me. How can i export datas to excel in the dataeditor per code? 

I found this: https://www.youtube.com/watch?v=90XHKSrYN-E but this isn't  with a script. 

Thank you in advance! 

- Steven

 

Labels (3)
5 Replies
Highlighted
Master II
Master II

Re: Export to Excel by script with Qlik Sense

try like this:

 

Tmp:
Load *, if(date#(Date1,'YYYYMMDD')-date#(Date2,'YYYYMMDD')>365,'90%','other') as New;
LOAD * INLINE [
    Date1, Date2
    20190911, 20180911
    20190911, 20180411
    20190911, 20180910
];

store Tmp into Test.csv (txt);

 

Note: you can only export to Excel-csv. Other formats are not supported!

 

Highlighted
Anonymous
Not applicable

Re: Export to Excel by script with Qlik Sense

Thank you for the answer. So it's not possible to store it as a .xls (xlsx,...) file ? 

Highlighted
Master II
Master II

Re: Export to Excel by script with Qlik Sense

no, not possible!

only csv, txt and qvd!

Highlighted
Contributor II
Contributor II

Re: Export to Excel by script with Qlik Sense

Its possible to extract into excel format 

 

STORE * FROM [NAME] INTO [path/filename.xlsx](txt);

This works

Highlighted
Digital Support
Digital Support

Re: Export to Excel by script with Qlik Sense

Based on our documentation the types of file that you would be able to create are QVD, CSV and TEX as you can see in the statement below.


"The statement will create an explicitly named 
QVD, CSV, or TXT file." 

 

Here is a link for the help page: Store

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.