Discussion board where members can get started with Qlik Sense.
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!
try like this:
Load *, if(date#(Date1,'YYYYMMDD')-date#(Date2,'YYYYMMDD')>365,'90%','other') as New;
LOAD * INLINE [
store Tmp into Test.csv (txt);
Note: you can only export to Excel-csv. Other formats are not supported!
Thank you for the answer. So it's not possible to store it as a .xls (xlsx,...) file ?
no, not possible!
only csv, txt and qvd!
Its possible to extract into excel format
STORE * FROM [NAME] INTO [path/filename.xlsx](txt);
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