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: 
Anonymous
Not applicable

Store Qvd as CSV with special characters

Hi All,

How can I Store QVD as .CSV or .XLSX.

Please assist.

Regards,

Saad

5 Replies
oknotsen
Master III
Master III

For details on STORE, see here:

Store ‒ Qlik Sense

Use this example to store as CSV (as that effectively is a txt):

store mytable into myfile.txt (txt);

May you live in interesting times!
Anonymous
Not applicable
Author

HI Onno,

This gives me missing data in between.

Regards,

Saad

its_anandrjs

For CSV file storing do this

Store Table1 into TableName.csv(txt)

oknotsen
Master III
Master III

You will have to be more specific about what your problem is.

May you live in interesting times!
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Saad,

You cannot directly store QVD to CSV. You can however store loaded table to txt or csv files
You can store table in script only to text delimitted (not xlsx) files like csv or txt with defined delimiter.

Examples:

  1. STORE YourTable into YourTable .txt (txt, delimiter is ';' );
  2. STORE YourTable into YourTable .csv (txt, delimiter is ',' );

read more about delimiter here:

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/ScriptSpecifiers/del...

You are not able to store table to XLSX (in Script or automaticly) - you can only do this from the UI or use NPrinting Tool to create more advanced XLS exports.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.